On Friday 03 August 2001 09:26, macky wrote:
> im still in the dark when it comes to postgres..... is there a way i can
> know if there was a new entry on a table...
> i have a script that runs every 5 minutes... that script checks if
> there's a new entry in that table... and if YES there's a new entry ill do
> some processing...
Isn't this a perfect example of when a notification and listen setup would be
helpful (assuming that a trigger isn't acceptable)?
In response to
pgsql-novice by date
|Next:||From: Schnack, Malte||Date: 2001-08-03 10:45:03|
|Subject: limit the number of entries in a table|
|Previous:||From: Joseph||Date: 2001-08-03 10:06:38|
|Subject: function question|
pgsql-sql by date
|Next:||From: rocael||Date: 2001-08-03 13:08:13|
|Subject: `postgresql.conf' has wrong permissions???|
|Previous:||From: Christopher Sawtell||Date: 2001-08-03 10:05:14|
|Subject: Re: Knowing new item in table...|