[postgis-users] FOREIGN TABLES and spatial_ref_sys

[Martin Hoegh]

Just to clarify whats going on at the foreign server. No schema when querying spatial_ref_sys:

2017-12-18 20:26:20.460 UTC [14021] gc2 at dk LOG: statement: SET search_path = pg_catalog
2017-12-18 20:26:20.460 UTC [14021] gc2 at dk LOG: statement: SET timezone = 'UTC'
2017-12-18 20:26:20.461 UTC [14021] gc2 at dk LOG: statement: SET datestyle = ISO
2017-12-18 20:26:20.461 UTC [14021] gc2 at dk LOG: statement: SET intervalstyle = postgres
2017-12-18 20:26:20.461 UTC [14021] gc2 at dk LOG: statement: SET extra_float_digits = 3
2017-12-18 20:26:20.461 UTC [14021] gc2 at dk LOG: statement: START TRANSACTION ISOLATION LEVEL REPEATABLE READ
2017-12-18 20:26:20.497 UTC [14021] gc2 at dk LOG: execute <unnamed>: DECLARE c1 CURSOR FOR
SELECT gid, gml_id, objectid, temakode, temanavn, objekt_id, version_id, systid_fra, systid_til, oprettet, oprindkode, oprindelse, statuskode, status, off_kode, offentlig, cvr_kode, cvr_navn, bruger_id, link, draftstatus, listtoapprove, aendr_kode, aendrbegr, sagsbeh, "shape.starea__", "shape.stlength__", the_geom, dkilde FROM dai.kirkebyggelinjer WHERE ((public.st_distance(public.st_transform(the_geom, 3857), '0101000020110F00003A4A3D94B28430410B0C26BAA6065C41'::public.geometry) < 23::double precision))
2017-12-18 20:26:20.498 UTC [14021] gc2 at dk LOG: statement: FETCH 100 FROM c1
2017-12-18 20:26:20.498 UTC [14021] gc2 at dk ERROR: relation "spatial_ref_sys" does not exist at character 23
2017-12-18 20:26:20.498 UTC [14021] gc2 at dk QUERY: SELECT proj4text FROM spatial_ref_sys WHERE srid = 1 LIMIT 1
2017-12-18 20:26:20.498 UTC [14021] gc2 at dk STATEMENT: FETCH 100 FROM c1