Foreign Key bug -- 7.4b4
От | Rod Taylor |
---|---|
Тема | Foreign Key bug -- 7.4b4 |
Дата | |
Msg-id | 1065821692.60436.2.camel@jester обсуждение исходный текст |
Ответы |
Re: Foreign Key bug -- 7.4b4
|
Список | pgsql-hackers |
May have posted this earlier... It would seem that caching the plans for foreign keys has some unwanted side effects. test=# select version(); version ------------------------------------------------------------------------PostgreSQL 7.4beta4 on i386-portbld-freebsd4.8, compiledby GCC 2.95.4 (1 row) test=# test=# create table a (col integer primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "a_pkey" for table "a" CREATE TABLE test=# test=# create table b (col integer primary key references a on update cascade on delete cascade); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "b_pkey" for table "b" CREATE TABLE test=# test=# test=# insert into a values (1); INSERT 687978 1 test=# insert into b values (1); INSERT 687979 1 test=# test=# insert into a values (2); INSERT 687980 1 test=# insert into b values (2); INSERT 687981 1 test=# test=# delete from a where col = 1; DELETE 1 test=# test=# alter table b drop constraint b_pkey; ALTER TABLE test=# test=# delete from a where col = 2; ERROR: could not open relation with OID 687972
В списке pgsql-hackers по дате отправления: