Re: Typed tables - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Typed tables
Date
Msg-id 1257454071.11856.22.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Typed tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On tor, 2009-11-05 at 12:38 -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > One thing I'm not sure of is whether to keep the implicit row type in
> > that case.  That is, would the above command sequence still create a
> > "persons" type?
> 
> Are you intending that the table and the original composite type are
> independent, or are still tied together --- ie, does ALTER TABLE ADD
> COLUMN or similar affect the composite type?

They need to stay tied together.  But it's to be determined whether
ALTER TABLE ADD COLUMN would work on those tables or whether there would
be some kind of ALTER TYPE.



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: operator exclusion constraints
Next
From: Peter Eisentraut
Date:
Subject: Re: Typed tables