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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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