Skip site navigation (1) Skip section navigation (2)

Re: Adding column comment to information_schema.columns

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Justin Clift" <jc(at)telstra(dot)net>
Cc: "PostgreSQL Hackers Mailing List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding column comment to information_schema.columns
Date: 2004-07-01 07:30:28
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40C37FA@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
 

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org 
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 01 July 2004 05:33
> To: Justin Clift
> Cc: PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] Adding column comment to 
> information_schema.columns 
> 
> Justin Clift <jc(at)telstra(dot)net> 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?

If you write code to use it, then by definition you are writing code
that is PostgreSQL specific and therefore not standard. If someone then
writes their code to PostgreSQLs implementation of the
information_schema, wanting reasonably portable code, but not realising
we've extended the standard then they could be in for surprise when they
come to run their code on another platform.

Ugh, just read that back - I need coffee....

I say keep it standard.

Regards Dave

pgsql-hackers by date

Next:From: Justin CliftDate: 2004-07-01 10:42:57
Subject: Bug with view definitions?
Previous:From: Andreas PflugDate: 2004-07-01 07:20:05
Subject: Re: Adding column comment to information_schema.columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group