create.sql

application/octet-stream

Filename: create.sql

Type: application/octet-stream

Part: 0

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

drop schema if exists test cascade;
create schema test;
create table test.table1 (
  id int not null,
  primary key (id));
create table  test.table2 (
  table1_id int not null,
  value  text not null,
  primary key (table1_id));
alter table test.table2 add foreign key (table1_id) references test.table1 (id);