Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TEMPORARY TABLE tmp (geom GEOMETRY);
INSERT INTO tmp VALUES ('SRID=4326;POINT (1 2)'),
                       ('SRID=4326;POINT (2 4)');
ERROR:  type "geometry" does not exist
LINE 1: CREATE TEMPORARY TABLE tmp (geom GEOMETRY);
                                         ^


SELECT geom FROM tmp;
ERROR:  relation "tmp" does not exist
LINE 1: SELECT geom FROM tmp;
                         ^


SELECT ST_AsText(geom),ST_AsEWKT(geom) FROM tmp;
ERROR:  relation "tmp" does not exist
LINE 1: SELECT ST_AsText(geom),ST_AsEWKT(geom) FROM tmp;
                                                    ^


SELECT ST_AsGeoJSON(geom) FROM tmp;
ERROR:  relation "tmp" does not exist
LINE 1: SELECT ST_AsGeoJSON(geom) FROM tmp;
                                       ^


SELECT ST_AsGML(geom) FROM tmp;
ERROR:  relation "tmp" does not exist
LINE 1: SELECT ST_AsGML(geom) FROM tmp;
                                   ^


SELECT ST_AsKML(geom) FROM tmp;
ERROR:  relation "tmp" does not exist
LINE 1: SELECT ST_AsKML(geom) FROM tmp;
                                   ^