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

From Peter Eisentraut
Subject Re: "stored procedures"
Date
Msg-id 1303758341.5006.62.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: "stored procedures"  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On mån, 2011-04-25 at 13:34 -0500, Merlin Moncure wrote:
> hm. does the sql standard prohibit the use of extra transactional
> features?

It doesn't prohibit anything.  It just kindly requests that standard
syntax has standard behavior.

> are you sure it's not implied that any sql (including
> START TRANSACTION etc) is valid?  meaning, unless otherwise specified,
> you should be able to do those things, and that our functions because
> they force one transaction operation are non-standard, not the other
> way around. 

Syntactically, it appears to be allowed, and there's something about
savepoint levels.  So that might be something related.  In any case, if
we use standard syntax, that should be researched.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: branching for 9.2devel
Next
From: Tom Lane
Date:
Subject: Re: Unlogged tables, persistent kind