From: | psql(at)dgrmm(dot)net |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | create table in transaction fails |
Date: | 2005-10-29 22:56:41 |
Message-ID: | 4363FE29.705@dgrmm.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2005-10-29 23:29:55 | Re: Generating an ANSI compliant schema recreation script |
Previous Message | J French | 2005-10-29 22:22:49 | Generating an ANSI compliant schema recreation script |