[Zope-DB] Psycopg, Zope & Autocommit

Michael Long mlong@datalong.com
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
none of 
> 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
issue 
> is and whether I need to change all my ZSQL-methods.
> 
> Thanx
> 
> Charlie
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
> 
>