Skip site navigation (1) Skip section navigation (2)

conditional alter table

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: conditional alter table
Date: 2008-05-30 22:09:30
Message-ID: 48407B1A.1040603@ca.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Tino WildenhainDate: 2008-05-31 06:53:31
Subject: Re: cannot use result of (insert .. returning)
Previous:From: Fernando MorenoDate: 2008-05-30 21:22:32
Subject: Re: syntax error with execute

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group