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 по дате отправления: