From: Andrew Sullivan <ajs@crankycanuck.ca>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: Syntax error while altering col-type
Date: Thu, 13 Jan 2005 07:05:49 -0500
Message-ID: <20050113120549.GA31357@phlogiston.dyndns.org> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB16542@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB16542@neptun.sonorys.at>
On Thu, Jan 13, 2005 at 09:48:02AM +0100, KÖPFERL Robert wrote:
> I'm a little bit perplexed now... is it really the case that pre 8.0 systems
> aren't able to change col-types?
It really is. In fact, the feature was (IIRC) somewhat
controversial, because there are all sorts of decisions that need to
be made about what to do with incompatible types. What if you change
from int8 to int4? What about varchar(4) to char(4)? Just to name
two simple-minded examples. See the -general and -hackers archives
for plenty of previous discussion of this stuff.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Syntax error while altering col-type
In-Reply-To: <20050113120549.GA31357@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox