Re: IF EXISTS

On 9/21/06, stevethames <steve(at)softlife(dot)com> wrote:
>
> Ok, thanks, Jeff.
> This is not a critical problem. Just annoying. I'll wait for 8.2.
> BTW, while I can see the reason for adding the IF EXISTS clause to the
> language for checking the existence of objects, wouldn't it be easier to
> simply provide the PL/PgSQL language for script loading? Then it would be
> possible to create scripts for database maintainance that could be run
> periodically without having to make them functions stored in the database.
> Just a thought.

Or, more importantly, be able to commit within a procedure, i.e.
make a LOOP which will COMMIT every 1000th iteration. Would
be great for scripting maintenance activities.

Regards,
Dawid