PostgreSQL: SQLSTATE[25P02]

533 views
Skip to first unread message

G65434-2

unread,
Mar 16, 2011, 4:28:35 PM3/16/11
to vimbadmin-discuss
Hello

I've tried to install ViMbAdmin under Debian Squeeze with PostgreSQL.
Unfortunaly the Installation failured on the Script-Call "./doctrine-
cli.php create-tables", cause the SQL-Error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current
transaction is aborted, commands ignored until end of transaction
block. Failing Query: "ALTER TABLE alias ADD CONSTRAINT
alias_domain_domain_domain FOREIGN KEY (domain) REFERENCES
domain(domain) NOT DEFERRABLE INITIALLY IMMEDIATE". Failing Query:
ALTER TABLE alias ADD CONSTRAINT alias_domain_domain_domain FOREIGN
KEY (domain) REFERENCES domain(domain) NOT DEFERRABLE INITIALLY
IMMEDIATE


You could find to this Error two Bug-Messages:

http://www.doctrine-project.org/jira/browse/DC-968

http://bugs.php.net/49985

but i don't know if that Bugs could be the reason or it is a bug in
the script doctrine-cli.php in use with PostgreSQL.

Installation:

Package: zendframework
Version: 1.10.6-1

Package: doctrine
Version: 1.2.2-2

Package: smarty3
Version: 3.0~rc1-1

Package: php5-cli
Version: 5.3.3-7

Package: postgresql
Version: 8.4.7-0squeeze2


MfG
Matthias
Reply all
Reply to author
Forward
0 new messages