On Mon, Nov 25, 2013 at 12:10:22PM -0800, Kevin Grittner wrote: > David Fetter <da...@fetter.org> wrote: > > On Mon, Nov 25, 2013 at 11:04:23AM -0800, Kevin Grittner wrote: > > >> As soon as we are out of this CF, I am planning to write code to > >> capture deltas and fire functions to process them "eagerly" > >> (within the creating transaction). There has been suggestions > >> that the changeset mechanism should be used for that, which I > >> will look into; but my gut feel is that it will be better to > >> build a tuplestore of tids flagged with "old" or "new" around > >> the point that "after triggers" fire. How close does that sound > >> to what CREATE ASSERTION (as currently envisioned) would need? > > > > It sounds *extremely* close to what we'd need for row access in > > per-statement triggers, as in probably identical. The SQL syntax > > of this sub-feature is described in Foundation section 11.49 and > > called REFERENCING in CREATE TRIGGER. > > > > Do you have any prototypes I could use for that purpose? > > No, but it is at the top of my list after the CF. I will also need > an execution node type or two to produce the referenced rows for > the appropriate contexts, which is probably also very close to what > you need for per-statement triggers. I will be happy to coordinate > work with you.
Now that the CF in question is over, how can I help? Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
