Skip to content

Commit 99a831f

Browse files
committed
covering_index scripts are fixed
1 parent c6d96b0 commit 99a831f

File tree

2 files changed

+2
-6
lines changed

2 files changed

+2
-6
lines changed

src/pgpro-upgrade/covering_index.sql

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,2 @@
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';
1+
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';
62
update pg_class set relnatts=25 where relname='pg_constraint';

src/pgpro-upgrade/covering_index.test

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

0 commit comments

Comments
 (0)