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/