Skip site navigation (1) Skip section navigation (2)

contrib modules and relkind check

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: contrib modules and relkind check
Date: 2017-01-24 05:14:08
Message-ID: ab91fd9d-4751-ee77-c87b-4dd704c1e59c@lab.ntt.co.jp (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
Some contrib functions fail to fail sooner when relations of unsupported
relkinds are passed, resulting in error message like one below:

create table foo (a int);
create view foov as select * from foo;
select pg_visibility('foov', 0);
ERROR:  could not open file "base/13123/16488": No such file or directory

Attached patch fixes that for all such functions I could find in contrib.

It also installs RELKIND_PARTITIONED_TABLE as unsupported in a couple of
places (in pageinspect and pgstattuple).

Thanks,
Amit

Attachment: 0001-Add-relkind-checks-to-certain-contrib-modules.patch
Description: text/x-diff (6.9 KB)

Responses

pgsql-hackers by date

Next:From: Amit KapilaDate: 2017-01-24 05:29:20
Subject: Re: parallelize queries containing subplans
Previous:From: Dilip KumarDate: 2017-01-24 04:59:32
Subject: Re: New SQL counter statistics view (pg_stat_sql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group