Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 584069FAC9B for ; Wed, 7 Mar 2007 03:31:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 50936-02 for ; Wed, 7 Mar 2007 03:30:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id 476039FA4D1 for ; Wed, 7 Mar 2007 03:30:56 -0400 (AST) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu2) with ESMTP (Nemesis), id 0MKwtQ-1HOqbu0Lsw-00054L; Wed, 07 Mar 2007 08:30:54 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HOqbt-0002jv-00 for pgsql-performance@postgresql.org; Wed, 07 Mar 2007 08:30:53 +0100 Date: Wed, 7 Mar 2007 08:30:53 +0100 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: When the Record Got Updated. Message-ID: <20070307073053.GB8257@a-kretschmer.de> References: <7e4ba9550703062243r4d122850u4f1af30cbf3a65e1@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7e4ba9550703062243r4d122850u4f1af30cbf3a65e1@mail.gmail.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: kundenserver.de abuse@kundenserver.de login:51ea9561fc3f6d9539a2acd743e4748c X-Provags-ID2: V01U2FsdGVkX19trXTf2/M9K/k5fHkgN2uF/TYlNs/XRYgnhKX E1GK+5IJxspKQyBlFF7MqovE0fPNK0K+3RjihVV48xQG+boDDD 0ElQLBF713+EGSTzsNTU7lmsdF0THwI X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.306 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200703/148 X-Sequence-Number: 23553 am Wed, dem 07.03.2007, um 12:13:55 +0530 mailte Gauri Kanekar folgendes: > Hi List, > > Can i find out the timestamp when last a record from a table got updated. > Do any of the pg system tables store this info. No, impossible. But you can write a TRIGGER for such tasks. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net