Skip site navigation (1) Skip section navigation (2)

Re: Knowing new item in table...

From: Ken Corey <ken(dot)corey(at)atomic-interactive(dot)com>
To: "macky" <macky(at)edsamail(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Knowing new item in table...
Date: 2001-08-03 10:27:31
Message-ID: 0108031127310C.28897@kcorey.intra.atomic-interactive.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
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...
>
> scenario...
>
>   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)?

-Ken

In response to

pgsql-novice by date

Next:From: Schnack, MalteDate: 2001-08-03 10:45:03
Subject: limit the number of entries in a table
Previous:From: JosephDate: 2001-08-03 10:06:38
Subject: function question

pgsql-sql by date

Next:From: rocaelDate: 2001-08-03 13:08:13
Subject: `postgresql.conf' has wrong permissions???
Previous:From: Christopher SawtellDate: 2001-08-03 10:05:14
Subject: Re: Knowing new item in table...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group