Brian Cox wrote: > I'd like to either 1) execute an alter table to re-add a constraint only > if it doesn't exist or 2) have psql ignore the failure when setting it's > exit status. Any ideas on how to do either would be appreciated.
I don't think there's a way to do that but you can look at the pg_constraint table to see if it exists. http://www.postgresql.org/docs/current/static/catalog-pg-constraint.html -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
