Re: conditionally executing migration code

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
<michael_soulier(at)mitel(dot)com> wrote:
> 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 such situations, but it's not always easy.
>
> Thanks,
> Mike
> --
> Michael P. Soulier <michael_soulier(at)mitel(dot)com>, 613-592-2122 x2522
> "Any intelligent fool can make things bigger and more complex... It
> takes a touch of genius - and a lot of courage to move in the opposite
> direction." --Albert Einstein
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>