Re: Syntax error while altering col-type

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
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 12:30:21
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB16549@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> 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.
>

but that's the reason, the USING clause exists. It however still remains a
problem if triggers, constraints or referential integrity or vews are
involved.

so far

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-01-13 13:25:32 Re: Syntax error while altering col-type
Previous Message Andrew Sullivan 2005-01-13 12:05:49 Re: Syntax error while altering col-type