diff options
Diffstat (limited to 'src/test/regress/sql/indexing.sql')
| -rw-r--r-- | src/test/regress/sql/indexing.sql | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/src/test/regress/sql/indexing.sql b/src/test/regress/sql/indexing.sql index e60f3fb932..429120e710 100644 --- a/src/test/regress/sql/indexing.sql +++ b/src/test/regress/sql/indexing.sql @@ -522,7 +522,7 @@ create table idxpart3 (b int not null, a int not null); alter table idxpart attach partition idxpart3 for values from (20, 20) to (30, 30); select conname, contype, conrelid::regclass, conindid::regclass, conkey from pg_constraint where conrelid::regclass::text like 'idxpart%' - order by conrelid::regclass::text, conname; + order by conname; drop table idxpart; -- Verify that multi-layer partitioning honors the requirement that all @@ -620,11 +620,9 @@ create table idxpart (a int) partition by range (a); create table idxpart0 (like idxpart); alter table idxpart0 add unique (a); alter table idxpart attach partition idxpart0 default; -alter table only idxpart add primary key (a); -- works, but idxpart0.a is nullable -\d idxpart0 -alter index idxpart_pkey attach partition idxpart0_a_key; -- fails, lacks NOT NULL +alter table only idxpart add primary key (a); -- fail, no NOT NULL constraint alter table idxpart0 alter column a set not null; -alter index idxpart_pkey attach partition idxpart0_a_key; +alter table only idxpart add primary key (a); -- now it works alter table idxpart0 alter column a drop not null; -- fail, pkey needs it drop table idxpart; |