DROP TABLE alter2.tt8;

DROP SCHEMA alter2;

-- Check that we map relation oids to filenodes and back correctly.

--Don't displayall themappings so the test output doesn't change

--all thetime, but make sure we actually do test some values.

--Only displaybadmappings so the test output doesn't change all the

-- time.

SELECT

SUM((mapped_oid != oid OR mapped_oid IS NULL)::int) incorrectly_mapped,

count(*) > 200 have_mappings

FROM (

SELECT

oid, reltablespace, relfilenode, relname,

pg_filenode_relation(reltablespace, pg_relation_filenode(oid)) mapped_oid

FROM pg_class

WHERE relkind IN ('r', 'i', 'S', 't', 'm')

) mapped;

incorrectly_mapped | have_mappings

--------------------+---------------

0 | t

(1 row)

oid, mapped_oid, reltablespace, relfilenode, relname

FROM pg_class,

pg_filenode_relation(reltablespace, pg_relation_filenode(oid)) AS mapped_oid

WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;

oid | mapped_oid | reltablespace | relfilenode | relname

-----+------------+---------------+-------------+---------

(0 rows)

-- Checks on creating and manipulation of user defined relations in

-- pg_catalog.

DROPSCHEMA alter2;

SUM((mapped_oid!=oidOR mapped_oid ISNULL)::int) incorrectly_mapped,

count(*)>200 have_mappings

FROM (

oid, reltablespace, relfilenode, relname,

pg_filenode_relation(reltablespace, pg_relation_filenode(oid)) mapped_oid

FROM pg_class

WHERE relkindIN ('r','i','S','t','m')

) mapped;

oid, mapped_oid, reltablespace, relfilenode, relname

FROM pg_class,

pg_filenode_relation(reltablespace, pg_relation_filenode(oid))AS mapped_oid

WHERE relkindIN ('r','i','S','t','m')AND mapped_oid IS DISTINCTFROMoid;