Re: Typed tables
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2009-11-05T17:38:52Z
Lists: 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