From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Unused system table columns |
Date: | 2002-07-16 04:36:53 |
Message-ID: | 1026794213.1939.11.camel@rh72.home.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2002-07-16 at 11:13, Tom Lane wrote:
> Hannu Krosing <hannu(at)tm(dot)ee> writes:
> >> We can always re-add the columns them.
>
> > But would it not be nice if we could add uniform binary protocol without
> > requiring initdb ?
>
> That won't happen, because the existing contents of those columns are
> completely useless for a binary-protocol feature.
>
> If we do ever add such a feature, we'd be better off adding new columns
> with a different name, just to avoid confusion over what's supposed to
> be there. (For example: extant pg_dump scripts for user-defined types
> will try to load wrong values into those columns if given a chance.
So you know some place that actually uses the values from these columns
?
Or is it just that we have told users long enough to make them same as
typinput/typoutput ?
> We *must* use new names for those slots in CREATE TYPE to avoid that
> pitfall, and so we might as well change the system column name too.)
Can't we just add a warning when typinput==typreceive or
typoutput==typsend, or just plain refuse to make them equal and force
people to create another function binding even if they are.
The interim solution would be to set typreceive/typsend to NULL if they
are the same as typinput/typoutput in CREATE TYPE.
-------------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-16 04:38:49 | Re: DROP COLUMN |
Previous Message | Joe Conway | 2002-07-16 04:19:59 | Re: bit type external representation |