Skip to content

Commit 6f1baa2

Browse files
committed
pgpro-upgade covering_index
1 parent 1baf0df commit 6f1baa2

File tree

2 files changed

+6
-0
lines changed

2 files changed

+6
-0
lines changed

src/pgpro-upgrade/covering_index.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
insert into pg_attribute
2+
select
3+
attrelid, 'conincluding', atttypid, attstattarget, attlen, 25, attndims, attcacheoff, atttypmod, attbyval, attstorage, attalign, attnotnull, atthasdef, attisdropped, attislocal, attinhcount, attcollation, attacl, attoptions, attfdwoptions
4+
from pg_attribute
5+
where attrelid = 'pg_constraint'::regclass::oid and attname ='conkey';

src/pgpro-upgrade/covering_index.test

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
select relnatts=25 from pg_class where relname='pg_constraint';

0 commit comments

Comments
 (0)