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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine
Дата
Msg-id b42b73150812080617k567597eftfee9bd4d5c8fac94@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Mon, Dec 8, 2008 at 8:01 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
> Merlin Moncure wrote:
>> Well, new features that have a perfectly acceptable and usable
>> workaround typically have a fairly low priority of fixing :-)
>>
>> Since tables are basically types, I'm not sure what the difference is
>> between tables and composite types (meaning, why do we have the
>> composite type syntax at all?)  I'm not sure if this came up during
>> the design discussion or not.
>
> Your "workaround" involves have a redundant table that you don't ever intend
> to populate.

Redundant how?  Since tables and types exist in the same namespace
(can't have table and type in the same schema with the same name), a
table is just a type with storage.  If that's a big deal, remove the
insert priv...

I like to keep the table based types I use in a special schema, like
'types' anyways.

merlin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Sync Rep: First Thoughts on Code
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Multiplexing SUGUSR1