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

\d test.table2

begin;
alter table		"test"."table2"
	drop constraint	"table2_table1_id_fkey";
alter table		"test"."table2"
	drop constraint	"table2_pkey";
drop index		"test"."testindex";
copy			"test"."table2"
	from		stdin;
1	test
\.
analyze			"test"."table2";

alter table		"test"."table2"
	add		foreign key		("table1_id")
				references	"test"."table1" ("id");
alter table		"test"."table2"
	add		primary key ("table1_id");
create index		"testindex"
	on		"test"."table2" ("value");
commit;

\d test.table2