-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have a php script to upgrade a database, and it works just fine when not in a transaction, but it fails when I turn on a transaction. I'm using: fedora core 4 postgresql 8.0.3 php-pgsql-4.3.11 The error is: [db_error: message="DB Error: unknown error" code=-1 mode=return level=notice prefix="" info="CREATE TABLE maia_themes ( id SERIAL PRIMARY KEY, name VARCHAR(30) NOT NULL, path VARCHAR(30) NOT NULL) [nativecode=ERROR: current transaction is aborted, commands ignored until end of transaction block]"] Any ideas why this fails? - -- David Morton -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDY/4pSIxC85HZHLMRAq3bAJ45rWELMRRFvATo1ZNIJRcv6mjzzwCeK7tV DWUHMCjuqtgvowPuXXS1xjM= =I5gY -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
