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

Поиск
Список
Период
Сортировка
От Dmitry Koterov
Тема ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine
Дата
Msg-id d7df81620812040653l45d61499g4c8f45475afe4e68@mail.gmail.com
обсуждение исходный текст
Ответы Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-hackers
Hello.<br /><br />I can successfully ALTER a NON-EMPTY table (ct) which ROWTYPE is used as a column type for another
table(dt):<br /><br />CREATE TABLE ct (id INTEGER);<br />CREATE TABLE dt (id INTEGER, c ct);<br /><br />INSERT INTO dt
VALUES(1,'(666)');<br /> SELECT * FROM dt;<br />-- (1, '(666)')<br /><br />ALTER TABLE ct ADD COLUMN n INTEGER;<br
/>SELECT* FROM dt;<br /> -- (1, '(666,)')<br /><br />You see, '(666,)' means that the new field is added
successfully.<br/><br /><br />But, if I declare ct as a COMPOSITE type (not a table), it is not permitted to ALTER this
type(Postgres says that there are dependensies on ct).<br /> Why?<br /> 

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: snapshot leak and core dump with serializable transactions
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Can't start postmaster on -HEAD