Re: Database Upgrade scripts (AKA Conditional SQL execution)

From: Joe Conway <mail(at)joeconway(dot)com>
To: Richard Rowell <richard(at)bowmansystems(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Database Upgrade scripts (AKA Conditional SQL execution)
Date: 2003-07-07 15:20:05
Message-ID: 3F098FA5.4000808@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Richard Rowell wrote:
> Can I accomplish this with postgresql without involving an external
> process (like say perl)? I guess I could put the upgrade stuff into
> PL/SQL functions and just drop the functions when I'm done, but I was
> hoping for something a little "cleaner".
>

There is no way (currently at least) to do this without some kind of
function. I've done it in the past with PL/pgSQL. We've had brief
discussions in the past about how this could be supported, but nothing
conclusive, and no one has cared enough to scratch this particular itch.

Joe

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-07-07 15:44:01 Re: Concat and view - Re: create view error
Previous Message markus brosch 2003-07-07 15:15:55 max length of sql select statement ?