[Zope] Postgres and transactions

Hannu Krosing hannu@tm.ee
Fri, 11 May 2001 09:17:16 +0500


John Morton wrote:
> 
> I'm attempting to use a ZSQL method to create a new user in a postgresql
> database (in the CREATE USER... sense), using Popy and postgres 7.0. The
> problem is that CREATE USER throws an error if you use it inside an explicit
> transaction.

I see no problem here:

hannu=# begin;
BEGIN
hannu=#  create user hu;
CREATE USER
hannu=# commit;
COMMIT
hannu=# 


maybe your zope user has no right to create new users ?

-------------
Hannu