Re: [GENERAL] use a variable name for an insert in a trigger for an audit

2010-12-09 Thread Merlin Moncure
On Thursday, December 9, 2010, Raimon Fernandez wrote: > > On 9dic, 2010, at 04:40 , Raimon Fernandez wrote: > >> Hello, >> >> I have to audit all the changes for all rows of one database. >> >> I have a trigger that executes BEFORE any update or delete, and simply copy >> the row (INSERT INTO) i

Re: [GENERAL] use a variable name for an insert in a trigger for an audit

2010-12-09 Thread Raimon Fernandez
On 9dic, 2010, at 04:40 , Raimon Fernandez wrote: > Hello, > > I have to audit all the changes for all rows of one database. > > I have a trigger that executes BEFORE any update or delete, and simply copy > the row (INSERT INTO) into the replicated table. > > For example, every table has the

[GENERAL] use a variable name for an insert in a trigger for an audit

2010-12-08 Thread Raimon Fernandez
Hello, I have to audit all the changes for all rows of one database. I have a trigger that executes BEFORE any update or delete, and simply copy the row (INSERT INTO) into the replicated table. For example, every table has the same name plus '_audit' at the end and belongs to the schema audit: