1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
-- test oid columns (removed in PostgreSQL 12)
SELECT setting::int >= 120000 AS is_pg_12 FROM pg_settings WHERE name = 'server_version_num';
is_pg_12
----------
t
(1 row)
SELECT * FROM pg_dirtyread('foo') AS t(oid oid, bar bigint, baz text);
ERROR: Error converting tuple descriptors!
DETAIL: Attribute "oid" does not exist in type foo.
-- error cases
SELECT * FROM pg_dirtyread('foo') as t(oid bigint);
ERROR: Error converting tuple descriptors!
DETAIL: Attribute "oid" does not exist in type foo.
|
