Bug with CREATE CONSRAINT TRIGGER and attisdropped
От | Christopher Kings-Lynne |
---|---|
Тема | Bug with CREATE CONSRAINT TRIGGER and attisdropped |
Дата | |
Msg-id | GNELIHDDFBOCMGBFGEFOOELHCDAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответы |
Re: Bug with CREATE CONSRAINT TRIGGER and attisdropped
|
Список | pgsql-hackers |
CREATE CONSTRAINT TRIGGER doesn't respect attisdropped. Unfortunately I really don't have the time to submit a patch at the moment - sorry :( ctest=# create table master (x int unique, y int4 unique); NOTICE: CREATE TABLE / UNIQUE will create implicit index 'master_x_key' for table 'master' NOTICE: CREATE TABLE / UNIQUE will create implicit index 'master_y_key' for table 'master' CREATE TABLE test=# create table slave (a int); CREATE TABLE test=# alter table master drop x; ALTER TABLE test=# create constraint trigger "$1" after insert or update on "slave" from master not deferrable initially immediate for each row execute procedure "RI_FKey_check_ins" ('$1', 'slave', 'master', 'UNSPECIFIED', 'a', 'x'); CREATE TRIGGER test=# insert into master values (1); INSERT 16982 1 test=# insert into slave values (2); ERROR: constraint $1: table master does not have an attribute x Chris
В списке pgsql-hackers по дате отправления: