[Zope-DB] Postgres - Problem creating new databases

Andrew Veitch andrew@logicalprogression.net
Fri, 08 Nov 2002 10:51:05 +0000


I'm trying to create new databases from Zope, using psycopg and Postgres.
I've tried from ZSQL methods, calling psycopg directly and by
os.system("createdb") but I keep getting the same error:

ERROR: CREATE DATABASE: may not be called in a transaction block CREATE
DATABASE lp

If I cut the code out of my product and run it at the python prompt it works
fine.

Any ideas how I can get round this?

Thanks in advance

Andrew

-- 
Logical Progression Ltd, 3 Randolph Crescent, Edinburgh, EH3 7TH, UK
Tel: +44 (0)131 466 9585 Web: http://www.logicalprogression.net/