Skip site navigation (1) Skip section navigation (2)

Per-statement Triggers (was Re: Proposal: realprocedures again (8.4))

From: David Fetter <david(at)fetter(dot)org>
To: James Mansion <james(at)mansionfamily(dot)plus(dot)com>,Josh Berkus <Josh(dot)Berkus(at)sun(dot)com>,Merlin Moncure <mmoncure(at)gmail(dot)com>,Gregory Stark <stark(at)enterprisedb(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Per-statement Triggers (was Re: Proposal: realprocedures again (8.4))
Date: 2007-10-30 15:06:18
Message-ID: 20071030150618.GV14638@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Oct 30, 2007 at 11:33:19AM -0300, Alvaro Herrera wrote:
> James Mansion wrote:
> > Josh Berkus wrote:
> >> Not only would they be generally useful for SP programming, but
> >> multisets would eliminate one of the big hurdles in re-writing
> >> T-SQL stored procedures in PG, and thus make it easier to port
> >> from SQL Server.  You don't hear a lot of demand for multisets on
> >> the mailing lists because we're not getting those SQL Server /
> >> Sybase crossovers now.
> >>   
> > Its true that multiple result sets are a big deal with T-SQL
> > programming: but I think you'll also need to provide a way for the
> > locking model to behave in a similar way and also very importantly
> > to be able to emulate the after-statement triggers view of new and
> > old images.
> 
> I don't think we need to (or, for that matter, are able to) change
> the locking model, but the NEW and OLD views of for-statement
> triggers should be just a SMOP.

Having NEW and OLD views of per-statement triggers would be a Very
Nice Feature(TM) independent of stored procedures.  For one thing, it
would make certain kinds of replication trivial.

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

pgsql-hackers by date

Next:From: David FetterDate: 2007-10-30 15:11:00
Subject: Jagged Rows (was Re: Proposal: real procedures again(8.4))
Previous:From: David FetterDate: 2007-10-30 15:03:37
Subject: Re: Proposal: real procedures again (8.4)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group