test.sql

application/octet-stream

Filename: test.sql

Type: application/octet-stream

Part: 1

Message: Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done

begin;
alter table test.table2 drop constraint table2_table1_id_fkey;
copy test.table2 from  stdin;
1	test
\.
analyze test.table2;
alter table test.table2 add foreign key (table1_id) references test.table1 (id);
commit;