From: Sam Mason <sam@samason.me.uk>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: Syntax error while altering col-type
Date: Thu, 13 Jan 2005 10:19:23 +0000
Message-ID: <20050113101923.GY14073@sam.samason.me.uk> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB16542@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB16542@neptun.sonorys.at>
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?
I would guess that the column type altering code is just short hand
for creating a new column of the correct type, copying the old column
into the new one, deleting the old column, and renaming the new column
to be the same as the old one.
That is just a guess though! But if it's all bundled inside a
transaction it should have about the same semantics, shouldn't it?
Cheers,
Sam
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: sam@samason.me.uk
Subject: Re: Syntax error while altering col-type
In-Reply-To: <20050113101923.GY14073@sam.samason.me.uk>
* 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