Re: Syntax error while altering col-type - Mailing list pgsql-sql

From Sam Mason
Subject Re: Syntax error while altering col-type
Date
Msg-id 20050113101923.GY14073@sam.samason.me.uk
Whole thread Raw
In response to Re: Syntax error while altering col-type  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: Syntax error while altering col-type
Next
From: Dawid Kuroczko
Date:
Subject: Columns into rows.