pg_attribute.attisinherited ?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pg_attribute.attisinherited ?
Дата
Msg-id Pine.LNX.4.44.0208231806140.12046-100000@cm-lcon1-46-187.cm.vtr.net
обсуждение исходный текст
Ответы Re: pg_attribute.attisinherited ?
Список pgsql-hackers
This should not happen, I guess:

alvh=> CREATE TABLE test_inh (a int);
CREATE TABLE
alvh=> CREATE TABLE test_inh_child (b int) INHERITS (test_inh);
CREATE TABLE
alvh=> ALTER TABLE test_inh_child RENAME a TO c;
ALTER TABLE
alvh=> SELECT * FROM test_inh;
ERROR:  Relation "test_inh_child" has no column "a"

alvh=> ALTER TABLE test_inh_child RENAME c TO a;
ALTER TABLE
alvh=> ALTER TABLE test_inh_child DROP COLUMN a;
ALTER TABLE
alvh=> SELECT * FROM test_inh;
ERROR:  Relation "test_inh_child" has no column "a"


I remember Tom suggested adding something like attisinherited and
preventing this kind of operations on such attributes, because one can
do things such as

alvh=> ALTER TABLE test_inh_child ADD COLUMN a TEXT;
ALTER TABLE
alvh=> INSERT INTO test_inh_child VALUES (1, 'hello world');
INSERT 33449 1
alvh=> SELECT * FROM test_inh;
server closed the connection unexpectedly       This probably means the server terminated abnormally       before or
whileprocessing the request.
 
The connection to the server was lost.  Attempting reset: Failed.
!> 

-- 
Alvaro Herrera (<alvherre[a]atentus.com>)
"Entristecido, Wutra
echa a Freyr a rodar
y a nosotros al mar" (cancion de Las Barreras, Heliconia)



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Permissions for CREATE OPERATOR CLASS
Следующее
От: Vince Vielhaber
Дата:
Сообщение: Re: v7.2.2 Released ... but not announced ...