Trigger Variables

Started by Oluwatope Akinniyiover 20 years ago2 messagesgeneral
Jump to latest
#1Oluwatope Akinniyi
tope.akinniyi@shepherdhill.biz

I must commend the efforts of the developers and users of PostgreSQL for
new innovations and development. Thank you for giving us such a
wonderful DB.

I really was impressed with the set of Trigger variables that make
internal workings of trigger accessible to users. Of note is an easier
way of performing audits.

If I may ask, would it not be possible to add another advancement to the
world's open source most advanced database. I wish we could make
auditing semi-automatic. I was thinking of adding a parameter to CREATE
TABLE command to specify if an audit process would be added to the new
table on creation or not; just like the serial parameter would handle
the processes of sequence setup.

Thank you all.

Tope Akinniyi
ShepherdHill Software
Lagos, Nigeria.

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Oluwatope Akinniyi (#1)
Re: Trigger Variables

On Thu, Aug 04, 2005 at 12:03:03PM +0100, Oluwatope Akinniyi wrote:

If I may ask, would it not be possible to add another advancement to the
world's open source most advanced database. I wish we could make
auditing semi-automatic. I was thinking of adding a parameter to CREATE
TABLE command to specify if an audit process would be added to the new
table on creation or not; just like the serial parameter would handle
the processes of sequence setup.

"SERIAL" is a pseudo-type.

But I don't understand what you're asking. Perhaps you could give an
example of the syntax you would like and what exactly you would like it
to do. Your description above is not enough for me to give an
opinion...

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.