Received: from deborah.paradise.net.nz (deborah.paradise.net.nz [203.96.152.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f73A4gf61301; Fri, 3 Aug 2001 06:04:43 -0400 (EDT) (envelope-from csawtell@paradise.net.nz) Received: from there (202-0-37-152.cable.paradise.net.nz [202.0.37.152]) by deborah.paradise.net.nz (Postfix) with SMTP id EFF281F9FC3; Fri, 3 Aug 2001 22:04:38 +1200 (NZST) Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell To: "macky" , , Subject: Re: Knowing new item in table... Date: Fri, 3 Aug 2001 22:05:14 +1200 X-Mailer: KMail [version 1.2.3] References: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> In-Reply-To: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20010803100438.EFF281F9FC3@deborah.paradise.net.nz> X-Archive-Number: 200108/31 X-Sequence-Number: 4252 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 <-