Re: "stored procedures" - Mailing list pgsql-hackers

From Robert Haas
Subject Re: "stored procedures"
Date
Msg-id FA40E036-FB50-46B5-84BE-4CA2607B210B@gmail.com
Whole thread Raw
In response to Re: "stored procedures"  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: "stored procedures"  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Apr 21, 2011, at 3:51 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> If you do it that (base it on AT) way, then you can't:
> 1) call any utility command (vacuum, etc)
> 2) run for an arbitrary amount of time
> 3) discard any locks (except advisory)
> 4) deal with serialization isolation/mvcc snapshot issues that plague functions.

It is not obvious to me that you cannot do these things.
>

...Robert

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Formatting Curmudgeons WAS: MMAP Buffers
Next
From: Robert Haas
Date:
Subject: Re: Patch for pg_upgrade to turn off autovacuum