Re: [GENERAL] conditionally executing migration code

2008-06-05 Thread Scott Marlowe
Can't you just try to add the column and catch the error? If you're in a transaction use a user defined function to run it an catch the exception in pl/pgsql. On Thu, Jun 5, 2008 at 12:15 PM, Michael P. Soulier <[EMAIL PROTECTED]> wrote: > I'm using some simple migration code to execute individua

[GENERAL] conditionally executing migration code

2008-06-05 Thread Michael P. Soulier
I'm using some simple migration code to execute individual fragments of SQL code based on the version of the schema. Is there a way to perform an ALTER TABLE conditionally? Example: I want to add column foo to table bar, but only if column foo does not exist already. I'm trying to avoid suc