Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine - Mailing list pgsql-hackers

From Andrew Chernow
Subject Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine
Date
Msg-id 493FD652.5030509@esilo.com
Whole thread Raw
In response to Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan wrote:
> 
> This whole debate seems moot. We're not going to remove composite types 
> created with CREATE TYPE, so the rest is irrelevant. We don't have the 
> luxury of revisiting such decisions made many years ago, whether or not 
> you think they were good.
> 
> 

You can always fix something.  It can be deprecated in favor of a 
cleaner and more elagant method.

My two cents ... I never use CREATE TYPE AS, seems redundant and 
limited.  I use CREATE TABLE and just never insert any records.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine
Next
From: Simon Riggs
Date:
Subject: Re: Sync Rep: First Thoughts on Code