Skip to content

Commit 09b879d

Browse files
committed
split covering into two scripts
1 parent 99a831f commit 09b879d

File tree

3 files changed

+2
-1
lines changed

3 files changed

+2
-1
lines changed

src/pgpro-upgrade/covering_index.sql

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,2 +1 @@
11
insert into pg_attribute select attrelid, 'conincluding', atttypid, attstattarget, attlen, 25, attndims, attcacheoff, atttypmod, attbyval, attstorage, attalign, attnotnull, atthasdef, attisdropped, attislocal, attinhcount, attcollation, attacl, attoptions, attfdwoptions from pg_attribute where attrelid = 'pg_constraint'::regclass::oid and attname ='conkey';
2-
update pg_class set relnatts=25 where relname='pg_constraint';
Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
update pg_class set relnatts=25 where relname='pg_constraint';
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)