Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9F98476267 for ; Fri, 22 Nov 2002 21:43:52 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 09EC14760CE for ; Fri, 22 Nov 2002 21:43:52 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gAN2hssX001001; Fri, 22 Nov 2002 21:43:55 -0500 (EST) To: "Jason E. Stewart" Cc: pgsql-interfaces@postgresql.org Subject: Re: Frontend/Backend protocol changes? In-reply-to: <87d6ox6vpd.fsf@openinformatics.com> References: <87of8ha7ch.fsf@openinformatics.com> <25204.1037984494@sss.pgh.pa.us> <877kf5a5md.fsf@openinformatics.com> <26177.1037992260@sss.pgh.pa.us> <87ptsx70gz.fsf@openinformatics.com> <28828.1038004623@sss.pgh.pa.us> <87d6ox6vpd.fsf@openinformatics.com> Comments: In-reply-to "Jason E. Stewart" message dated "22 Nov 2002 16:17:18 -0700" Date: Fri, 22 Nov 2002 21:43:54 -0500 Message-ID: <1000.1038019434@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/110 X-Sequence-Number: 3358 "Jason E. Stewart" writes: > BTW, is there some other way to have all rows in a table automatically > timestamped? That would satisfy 99% of what I need. Sure; set up a BEFORE INSERT OR UPDATE trigger to assign to a timestamp column. regards, tom lane