From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruno Wolff III <bruno(at)wolff(dot)to>
Cc:
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Hannu Krosing <hannu(at)tm(dot)ee>, Justin Clift <jc(at)telstra(dot)net>,PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Adding column comment to information_schema.columns
Date:
2004-07-02 17:04:14
Message-ID:
15873.1088787854@sss.pgh.pa.us (view raw or flat )
Thread:
2004-07-01 03:00:15 from Justin Clift <jc(at)telstra(dot)net>
2004-07-01 04:33:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-07-01 04:35:43 from Justin Clift <jc(at)telstra(dot)net>
2004-07-01 07:20:05 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2004-07-01 16:38:02 from jearl(at)bullysports(dot)com
2004-07-01 17:04:33 from Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
2004-07-01 17:07:31 from Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
2004-07-01 17:30:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-07-02 02:24:58 from "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
2004-07-02 02:50:45 from Justin Clift <jc(at)telstra(dot)net>
2004-07-01 17:23:10 from Bruno Wolff III <bruno(at)wolff(dot)to>
2004-07-01 21:08:51 from Jochem van Dieten <jochemd(at)gmail(dot)com>
2004-07-01 22:11:09 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2004-07-02 02:05:57 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-02 02:07:35 from Justin Clift <jc(at)telstra(dot)net>
2004-07-02 11:57:18 from Hannu Krosing <hannu(at)tm(dot)ee>
2004-07-02 14:12:07 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2004-07-02 14:30:05 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-02 15:03:12 from Bruno Wolff III <bruno(at)wolff(dot)to>
2004-07-02 17:04:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-07-02 20:41:06 from Hannu Krosing <hannu(at)tm(dot)ee>
2004-07-03 10:02:01 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-03 14:06:48 from Bruno Wolff III <bruno(at)wolff(dot)to>
2004-07-05 02:52:46 from Justin Clift <jc(at)telstra(dot)net>
2004-07-05 03:11:10 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-05 03:58:10 from Justin Clift <jc(at)telstra(dot)net>
2004-07-05 04:13:38 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-05 04:20:27 from Justin Clift <jc(at)telstra(dot)net>
2004-07-05 04:38:48 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-05 04:41:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-07-05 07:48:22 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2004-07-02 17:50:08 from Jochem van Dieten <jochemd(at)gmail(dot)com>
2004-07-03 02:51:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-07-03 11:07:59 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-01 07:11:27 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-01 05:42:58 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-07-01 05:54:44 from Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Lists:
pgsql-hackers
Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> wrote:
>> Why are they useful???? If you want PG specific stuff then use the PG
>> specific catalogs!!!
> The information schema could be used to provide a more stable interface.
> The pg catalog changes from release to release and it would be nice to
> be able to write code which is more future proof.
Isn't this argument self-contradictory? The reason information_schema
is stable is that it is standard. If we start hacking it up to add
implementation-specific stuff, then you lose that stability. You'll
need to consider the PG version when deciding what queries you can
issue, and there will undoubtedly be scenarios where we have to change
or remove columns that we've added to information_schema. (We do not
whack the system catalogs around without good reason, after all.)
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Andrew DunstanDate: 2004-07-02 17:07:32Subject : Re: compile errors in new PL/PlerPrevious :From : Joshua D. DrakeDate : 2004-07-02 16:48:54Subject : Re: compile errors in new PL/Pler
