[Zope] Postgres and transactions

[Hannu Krosing]

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