From: Christopher Sawtell <csawtell@paradise.net.nz>
To: macky <macky@edsamail.com>
To: pgsql-sql@postgresql.org
To: pgsql-novice@postgresql.org
Subject: Re: Knowing new item in table...
Date: Fri, 3 Aug 2001 22:05:14 +1200
Message-ID: <20010803100438.EFF281F9FC3@deborah.paradise.net.nz> (raw)
In-Reply-To: <006501c11bf5$f4b20750$5764a8c0@edsamail.com>
References: <006501c11bf5$f4b20750$5764a8c0@edsamail.com>
On Fri, 03 Aug 2001 20: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...
>
>
> is there an internal utility that i can use in postgres that can tell me
> that this rows a new commers... hehehe....
>
>
> if someone has other ideas on how to deal with this speak out...
Here's mine:
Make sure the tables you wish to check have an id field of type SERIAL.
Then check the last entry number in the associated sequence when you wish to
check for new entries.
That will tell you if there are any new entries.
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ paradise . net . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-> Please refrain from using HTML or WORD attachments in e-mails to me <-
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: csawtell@paradise.net.nz, macky@edsamail.com, pgsql-novice@postgresql.org
Subject: Re: Knowing new item in table...
In-Reply-To: <20010803100438.EFF281F9FC3@deborah.paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox