Hi all, coul I delete a constraint made over a postgresql table? (In the parent table). The child doesn`t have records.
I'm not sure to have correctly understood what you mean :-/ Anyway, to delete a constraint you need to use an ALTER TABLE command.
ALTER TABLE [ ONLY ] table
DROP CONSTRAINT constraint { RESTRICT | CASCADE }/!\ The DROP CONSTRAINT constraint clause drops all constraints on the table (and its children) that match constraint.
More details on http://www.postgresql.org/docs/view.php?version=7.2&idoc=1&file=sql-altertable.html
SQL commands supported by PostgreSQL (here for v7.2): http://www.postgresql.org/docs/view.php?version=7.2&idoc=1&file=sql-commands.html
By the way, does any one know a good postgresql administrator like mysqladmin??Check this URL: http://gborg.postgresql.org/browse.php?83
phpPgAdmin: http://phppgadmin.sourceforge.net pgAdmin (for windows): http://www.pgadmin.org/
Thank´s Norma Ramirez
Cheers, Pascal
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
