Re: [GENERAL] An alternatives to rules and triggers

2007-05-05 Thread Karsten Hilbert
On Sat, May 05, 2007 at 03:01:36PM +1200, Glen Eustace wrote: Is there some way that one can determine whether a table has changed i.e. an insert, delete, update, without having to resort to setting a flag in another table using a triger or rule. You can NOTIFY a LISTENing client which does

[GENERAL] An alternatives to rules and triggers

2007-05-04 Thread Glen Eustace
Is there some way that one can determine whether a table has changed i.e. an insert, delete, update, without having to resort to setting a flag in another table using a triger or rule. I was wondering whether one of the system relations keep track of whether a table has been modifed.

Re: [GENERAL] An alternatives to rules and triggers

2007-05-04 Thread Tom Lane
Glen Eustace [EMAIL PROTECTED] writes: I was wondering whether one of the system relations keep track of whether a table has been modifed. Nope. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [GENERAL] An alternatives to rules and triggers

2007-05-04 Thread brian
Glen Eustace wrote: Is there some way that one can determine whether a table has changed i.e. an insert, delete, update, without having to resort to setting a flag in another table using a triger or rule. I was wondering whether one of the system relations keep track of whether a table has