[Zope-DB] Psycopg, Zope & Autocommit
Fri, 08 Nov 2002 14:51:24 -0500
You need to add a semi-colon to the end of the statement. For example:
CREATE TABLE security_role (
rolename VARCHAR(64) PRIMARY KEY NOT NULL
> On 2002-11-08 at 20:24:56 [+0100], Charlie Clark wrote:
> > Dear list,
> > can anybody tell me how to enable autocommit in psycopg on Linux? It
> > seems it's enable by default in windows and I don't want to have to
> > change all my ZSQL-methods juts to add commit;
> Sorry I need to correct myself having read up on autocommit which is not
> available in Zope for good reasons.
> But I still have a problem! All my ZSQL-methods are written like
> create table person
> (blah INTEGER)
> and they've all been working fine until now. I've just switched to
> PostgreSQL using psycopg and I didn't have to change anything in windows.
> Having just installed my application on a Linux server I find that
> the methods are really being called unless I add "commit;" at the end of
> the method. It would be great if someone could explain to me what the
> is and whether I need to change all my ZSQL-methods.
> Zope-DB mailing list