Re: "stored procedures" - use cases?

From: "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "stored procedures" - use cases?
Date: 2011-04-25 20:10:33
Message-ID: 4DB5D539.4050506@blackducksoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut wrote:
>
> Another point, as there appear to be diverging camps about
> supertransactional stored procedures vs. autonomous transactions, what
> would be the actual use cases of any of these features?

Looping over hundreds of identical schema executing DDL statements on
each. We can't do this in a single transaction because it consumes
all of shared memory with locks.

-- todd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2011-04-25 20:13:58 Re: Foreign table permissions and cloning
Previous Message Pavel Stehule 2011-04-25 20:10:01 Re: SQLERRD and dump of variables