conditional alter table

От:

Brian Cox <brian.cox@ca.com>

Дата:

31 мая 2008 г. в 00:16:22

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.

Posgres 8.1.2

Thanks,
Brian

Re: conditional alter table

От:

Chris <dmagick@gmail.com>

Дата:

1 июня 2008 г. в 21:47:43

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/