-- check that using any of these functions with unsupported relations will fail

create table test_partitioned (a int) partition by range (a);

create index test_partitioned_index on test_partitioned(a);

create index test_partitioned_hash_index on test_partitioned using hash(a);

-- these should all fail

select pgstattuple('test_partitioned');

ERROR: "test_partitioned" (partitioned table) is not supported

select pgstatginindex('test_partitioned');

ERROR: relation "test_partitioned" is not a GIN index

select pgstathashindex('test_partitioned');

ERROR: "test_partitioned" is not an index

ERROR: relation "test_partitioned" is not a hash index

select pgstathashindex('test_partitioned_hash_index');

ERROR: relation "test_partitioned_hash_index" is not a hash index

create view test_view as select 1;

-- these should all fail

select pgstattuple('test_view');

select pgstatginindex('test_view');

ERROR: relation "test_view" is not a GIN index

select pgstathashindex('test_view');

ERROR: "test_view" is notan index

ERROR:relation"test_view" is nota hash index

create foreign data wrapper dummy;

create server dummy_server foreign data wrapper dummy;

create foreign table test_foreign_table () server dummy_server;

select pgstatginindex('test_foreign_table');

ERROR: relation "test_foreign_table" is not a GIN index

select pgstathashindex('test_foreign_table');

ERROR: "test_foreign_table" is notan index

ERROR:relation"test_foreign_table" is nota hash index

-- a partition of a partitioned table should work though

create table test_partition partition of test_partitioned for values from (1) to (100);

select pgstattuple('test_partition');

select pgstatginindex('test_partition');

ERROR: relation "test_partition" is not a GIN index

select pgstathashindex('test_partition');

ERROR: "test_partition" is notan index

ERROR:relation"test_partition" is nota hash index

-- an actual index of a partitioned table should work though

create index test_partition_idx on test_partition(a);

create index test_partition_hash_idx on test_partition using hash (a);

float8free_percent;

uint64total_space;

rel=index_open(relid,AccessShareLock);

rel=relation_open(relid,AccessShareLock);

if (!IS_HASH(rel))

if (!IS_INDEX(rel)|| !IS_HASH(rel))

ereport(ERROR,

(errcode(ERRCODE_WRONG_OBJECT_TYPE),

errmsg("relation \"%s\" is not a hash index",

createtabletest_partitioned (aint) partition by range (a);

createindextest_partitioned_indexon test_partitioned(a);

createindextest_partitioned_hash_indexon test_partitioned using hash(a);

select pgstattuple('test_partitioned');

select pgstattuple('test_partitioned_index');

select pgstatindex('test_partitioned');

select pgstatginindex('test_partitioned');

select pgstathashindex('test_partitioned');

select pgstathashindex('test_partitioned_hash_index');

createviewtest_viewasselect1;