Re: Syntax error while altering col-type

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Syntax error while altering col-type
Date: 2005-01-13 10:19:23
Message-ID: 20050113101923.GY14073@sam.samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dawid Kuroczko 2005-01-13 10:26:04 Columns into rows.
Previous Message KÖPFERL Robert 2005-01-13 08:48:02 Re: Syntax error while altering col-type