On Wed, Jun 27, 2018 at 5:42 AM, Rajkumar Raghuwanshi
wrote:
> postgres=# alter index part_idx reset (fillfactor);
> ERROR: "part_idx" is not a table, view, materialized view, or index
I don't know whether that should work, but it seems like the error
message needs improvement, at the least.
On Thu, Jun 28, 2018 at 12:07 PM, Michael Paquier
wrote:
> On Thu, Jun 28, 2018 at 11:51:23AM +0530, Rajkumar Raghuwanshi wrote:
> > postgres=# select pgstatindex('part_pk');
> > ERROR: relation "part_pk" is not a btree index
>
> This error message is intentional. Please see bef5fcc and its
On Thu, Jun 28, 2018 at 11:51:23AM +0530, Rajkumar Raghuwanshi wrote:
> postgres=# select pgstatindex('part_pk');
> ERROR: relation "part_pk" is not a btree index
This error message is intentional. Please see bef5fcc and its related
thread:
another case where I got error like partition table index is not a index is
given below.
postgres=# create table part(a int, constraint part_pk primary key(a))
PARTITION BY RANGE(a);
CREATE TABLE
postgres=# create table part_p1 partition of part for values from
(minvalue) to (0);
CREATE TABLE