Received: from mail-relay1.sportal.net (mail-relay1.sportal.net [193.178.121.20]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f73AV0f68205; Fri, 3 Aug 2001 06:31:00 -0400 (EDT) (envelope-from ken.corey@atomic-interactive.com) Received: from lon_exch_2.sportal.int (lon_exch_2.sportal.int [192.168.20.88]) by mail-relay1.sportal.net (8.9.3/8.9.3) with ESMTP id LAA21221; Fri, 3 Aug 2001 11:29:32 +0100 (BST) Received: from kcorey.intra.atomic-interactive.com (KCOREY [192.168.90.50]) by lon_exch_2.sportal.int with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id PRH8YBH5; Fri, 3 Aug 2001 11:20:11 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Ken Corey Organization: Atomic Interactive, Ltd. To: "macky" , , Subject: Re: Knowing new item in table... Date: Fri, 3 Aug 2001 11:27:31 +0100 X-Mailer: KMail [version 1.2] References: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> In-Reply-To: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> MIME-Version: 1.0 Message-Id: <0108031127310C.28897@kcorey.intra.atomic-interactive.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/12 X-Sequence-Number: 1818 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