Received: from cmailg6.svr.pol.co.uk (cmailg6.svr.pol.co.uk [195.92.195.176]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f73A4qf61367; Fri, 3 Aug 2001 06:04:52 -0400 (EDT) (envelope-from tg_mail@bryncadfan.co.uk) Received: from modem-1505.lemur.dialup.pol.co.uk ([217.135.141.225] helo=parsley) by cmailg6.svr.pol.co.uk with smtp (Exim 3.13 #0) id 15Sbp3-0004Bw-00; Fri, 03 Aug 2001 11:04:49 +0100 From: "tamsin" To: , Subject: RE: Knowing new item in table... Date: Fri, 3 Aug 2001 11:03:37 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <006501c11bf5$f4b20750$5764a8c0@edsamail.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal X-Archive-Number: 200108/11 X-Sequence-Number: 1817 what kind of processing are you doing in the script? is there a reason why you are not using a trigger or rule on the table that is executed straight away when a new row is added? tamsin > -----Original Message----- > From: pgsql-novice-owner@postgresql.org > [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of macky > Sent: 03 August 2001 09:26 > To: pgsql-sql@postgresql.org; pgsql-novice@postgresql.org > Subject: [NOVICE] Knowing new item in table... > > > 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... > > thanks in advance...... > > btw.. > my idea is that that table will have an addtional column as reference > lets say column "READ" 1 for yes 0 for NO > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >