Re: Typed tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Typed tables
Date
Msg-id 24814.1257442732@sss.pgh.pa.us
Whole thread Raw
In response to Typed tables  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Typed tables
List pgsql-hackers
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?

If not, you *must* have a rowtype that is associated with the table.
        regards, tom lane


pgsql-hackers by date:

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