X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9CBE0D1E914 for ; Sun, 29 Feb 2004 02:01:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88266-06 for ; Sat, 28 Feb 2004 22:01:41 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 534B6D1D249 for ; Sat, 28 Feb 2004 22:01:37 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1T21am1011550; Sat, 28 Feb 2004 21:01:36 -0500 (EST) To: Richard Huxton Cc: Mark Lubratt , pgsql-hackers@postgresql.org Subject: Re: [ADMIN] Schema comparisons In-reply-to: <200402281759.50389.dev@archonet.com> References: <4F7D4521-69BC-11D8-ACD3-000A9579AF50@indeq.com> <27965.1077982780@sss.pgh.pa.us> <200402281759.50389.dev@archonet.com> Comments: In-reply-to Richard Huxton message dated "Sat, 28 Feb 2004 17:59:50 +0000" Date: Sat, 28 Feb 2004 21:01:35 -0500 Message-ID: <11549.1078020095@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/975 X-Sequence-Number: 50564 Richard Huxton writes: > I've been looking at storing $REVISION$ in comments for each object, so my > install scripts can halt if there is a problem. Not wanting to use my only > comment slot for this I was thinking about an extension to the COMMENT ON > statement: > COMMENT ON TABLE foo IS 'This is where I stroe my foos.'; > COMMENT ON TABLE foo SECTION 'default' IS 'I meant store my foos.'; > COMMENT ON TABLE foo SECTION 'revision' IS '1.19'; > COMMENT ON TABLE foo SECTION 'bar' IS 'baz'; This seems a little, um, specialized. Why don't you just keep the info in a user-defined table? regards, tom lane