pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTrigger Rowsets
2+ messages / 2 participants
[nested] [flat]
* Trigger Rowsets
@ 2005-11-02 23:34 Ralph Mason <ralph.mason@telogis.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ralph Mason @ 2005-11-02 23:34 UTC (permalink / raw)
To: pgsql-performance
I want to do statement level triggers for performance, but it seems
there is no 'updated', 'inserted', or 'deleted' tables inside the
trigger and nothing I can find in the documentation that offers similar
functionality.
Is there any way that I can access only those rows that were changed?
Thanks
Ralph
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Trigger Rowsets
@ 2005-11-02 23:50 Jim C. Nasby <jnasby@pervasive.com>
parent: Ralph Mason <ralph.mason@telogis.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jim C. Nasby @ 2005-11-02 23:50 UTC (permalink / raw)
To: Ralph Mason <ralph.mason@telogis.com>; +Cc: pgsql-performance
On Thu, Nov 03, 2005 at 12:34:14PM +1300, Ralph Mason wrote:
> I want to do statement level triggers for performance, but it seems
> there is no 'updated', 'inserted', or 'deleted' tables inside the
> trigger and nothing I can find in the documentation that offers similar
> functionality.
>
> Is there any way that I can access only those rows that were changed?
No. The only way you can do this is with row-level triggers. There's
also not currently any plans to allow statement-level triggers to
interact with the data that was modified by the statement.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-02 23:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-02 23:34 Trigger Rowsets Ralph Mason <ralph.mason@telogis.com>
2005-11-02 23:50 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox