Re: Typed tables

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Typed tables
Дата
Msg-id 1257454071.11856.22.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Typed tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: operator exclusion constraints
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Typed tables