agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] table level triggers?
Date: Sat, 12 Nov 2005 22:29:09 -0500
Message-ID: <200511122229.09406.dgovoni@metadapt.com> (raw)

Hi all,
? ?Pardons if this topic is located somewhere I have missed or has been 
already discussed, but is there a plan to ever have table-level triggers? My 
understanding is that current triggers fire on rows when an insert, 
update or delete occurs.
? ?I was thinking it would be nice to have one at the table level (called once 
for each result set on a table) with special attention to before/after 
"reads". This would allow privileged access control mechanisms to be 
developed for tables and pluggable via pljava. I know that there are some 
inside the database already, but with a custom trigger, it could do things 
like call out to a directory or some external resource to determine 
visibility.

Is this even a good idea?

Thank you!
Darren

view thread (2+ messages)  latest in thread

Message-ID: <200511122229.09406.dgovoni@metadapt.com>
Permalink:  ../200511122229.09406.dgovoni@metadapt.com/
Also on:    postgresql.org/message-id/200511122229.09406.dgovoni@metadapt.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] table level triggers?
  In-Reply-To: <200511122229.09406.dgovoni@metadapt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox