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 doe

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 be

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 increa

[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. ---