[Zope] More problems with postgresql users and zope.

15 May 2001

      I'm have some more problems with adding database users to a postgresql 
database. I've got a ZSQL method that looks like this:

Args: merchant_name password
Template:

insert into pg_shadow (
usename, usesysid, usecreatedb, usetrace, 
usesuper, usecatupd, passwd
) select 
<dtml-sqlvar merchant_name type="nb">, 
max(usesysid) + 1, 'f', 'f','f','f',
<dtml-sqlvar password type="nb"> 
from pg_shadow;

create table dummy (id int4 primary key);
grant select, insert on dummy to <dtml-var merchant_name>;

(The user add operation is a direct insert into the pg_shadow table as 
'create user' wraps itself in a transaction and fails to work from a ZSQL 
method as a results.)

The problem - this works inside a transaction from the console, but fails
when run through a Popy based DA with this error:

 Error, PoPy.ProgrammingError: ERROR: aclparse: non-existent user "foowww" 

Version are Popy/ZPopyDA 2.0.2, Zope 2.2.5, Postgresql 7.0.3

So what's going on here? Am I better off with a different adapter?

John

[Zope] More problems with postgresql users and zope.

John Morton