Re: [GENERAL] conditional alter table

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

[GENERAL] conditional alter table

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 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] conditional alter table add ?

On 17/10/2007, Lothar Behrens <[EMAIL PROTECTED]> wrote: > > Hi, > > I do convert an UML XMI model to a database script to create the > database schema. > To enable multiple iterations I need conditional alter table add > column like syntax. > > Is there any way to do this ? Not easily in a stra

[GENERAL] conditional alter table add ?

Hi, I do convert an UML XMI model to a database script to create the database schema. To enable multiple iterations I need conditional alter table add column like syntax. Is there any way to do this ? Tanks, Lothar ---(end of broadcast)--- TIP 2: