Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 6D0D69FB2E3 for ; Thu, 2 Nov 2006 15:04:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 24848-07 for ; Thu, 2 Nov 2006 15:04:51 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id BCB3F9FB2AF for ; Thu, 2 Nov 2006 15:04:52 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id g2so1242233nfe for ; Thu, 02 Nov 2006 11:04:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hRA18GPe52AuNOMMBa0zr6zwa5dbCBcWXLrVuaqXGLVSwuLFp6S914ykxV1/fW02NUM7zQoa2e26ZD6DVugksFO+DsElLBJufY+F7WPhASegQmSTgtPjwPupO2YZFbP8p7lGCIIzlrcNZzrn8k4tAgTrGYsjD4yDer3eXp9cGOw= Received: by 10.82.126.5 with SMTP id y5mr293475buc.1162494290710; Thu, 02 Nov 2006 11:04:50 -0800 (PST) Received: by 10.82.161.3 with HTTP; Thu, 2 Nov 2006 11:04:50 -0800 (PST) Message-ID: <1f30b80c0611021104v731894b2y47d544b478985cc9@mail.gmail.com> Date: Fri, 3 Nov 2006 00:04:50 +0500 From: imad To: "A. Kretschmer" Subject: Re: [SQL] Is there anyway to... Cc: pgsql-general@postgresql.org, "pgsql-sql@postgresql.org" In-Reply-To: <20061102182649.GA6846@a-kretschmer.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061102171624.GE21312@localhost> <454A357E.6010409@linuxlouis.net> <20061102182649.GA6846@a-kretschmer.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/111 X-Sequence-Number: 103207 Or you can probably use a PostgreSQL administration tool for scheduled jobs. I know a number of such tools which provide this feature and EnterpriseDB Management Server is one of them. --Imad www.EnterpriseDB.com On 11/2/06, A. Kretschmer wrote: > am Thu, dem 02.11.2006, um 13:14:22 -0500 mailte louis gonzales folgendes: > > Hello all, > > Is there an existing mechanism is postgresql that can automatically > > increment/decrement on a daily basis w/out user interaction? The use > > You can use CRON for such tasks. I hope for, you have a operating system > with a CRON... > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net > > ---------------------------(end of broadcast)--------------------------- > TIP 1: 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 >