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: (view raw, whole thread or download thread mbox)
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



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-2017 The PostgreSQL Global Development Group