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

From KÖPFERL Robert
Subject Re: Syntax error while altering col-type
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB16549@neptun.sonorys.at
Whole thread Raw
In response to Syntax error while altering col-type  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
Responses Re: Syntax error while altering col-type
List 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


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Syntax error while altering col-type
Next
From: Andrew Sullivan
Date:
Subject: Re: Syntax error while altering col-type