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: (view raw, whole thread or download thread mbox)
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)?


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-2017 The PostgreSQL Global Development Group