X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1D403D1B252 for ; Thu, 1 Jul 2004 01:36:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77428-02 for ; Thu, 1 Jul 2004 04:36:50 +0000 (GMT) Received: from mako1.telstra.net (mako1.telstra.net [203.50.0.28]) by svr1.postgresql.org (Postfix) with ESMTP id 62489D1B37C for ; Thu, 1 Jul 2004 01:36:48 -0300 (ADT) Received: from telstra.net (xena.telstra.net [203.50.0.233]) by mako1.telstra.net (8.12.9/8.11.1) with ESMTP id i614aoB4066724; Thu, 1 Jul 2004 14:36:50 +1000 (EST) (envelope-from jc@telstra.net) Message-ID: <40E3949F.6020201@telstra.net> Date: Thu, 01 Jul 2004 14:35:43 +1000 From: Justin Clift User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20040406 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PostgreSQL Hackers Mailing List Subject: Re: Adding column comment to information_schema.columns References: <40E37E3F.2050400@telstra.net> <22066.1088656403@sss.pgh.pa.us> In-Reply-To: <22066.1088656403@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/12 X-Sequence-Number: 55573 Tom Lane wrote: > Justin Clift writes: > >>Not sure how worthwhile others will find this small patch (to CVS HEAD), >>but we found it useful. It adds the column comments to the >>information_schema.columns view. > > > This question has been touched on before, but I guess it's time to face > it fair and square: is it reasonable for an SQL implementation to add > implementation-specific columns to an information_schema view? One > could certainly argue that the entire point of information_schema is > to be *standard*, not more, not less. OTOH I do not know if adding > an extra column is likely to break anyone's application. Comments? Well, I suppose it reduces application portability if anyone starts relying on it. ? Regards and best wishes, Justin Clift > regards, tom lane > >