PGadmin4.11 Ubuntu 18.04 Postgresql 11.4 I just tried to create the table below: CREATE TABLE teleon.to_location ( locn_id serial NOT NULL, geo_position geography(POINT, 4326) NOT NULL, upd_time timestamp NOT NULL, app_src_key char NOT NULL, CONSTRAINT to_location_pk PRIMARY KEY (locn_id)
I got : ERROR: type "geography" does not exist LINE 5: geo_position geography(POINT, 4326) NOT NULL, ^ SQL state: 42704 Character: 166 Here is the strange thing: I run this in psql and it works fine. I also have other tables in the system already defined with geography(POINT, 4326). This isn't related to the 'No results in 4.11 Ubuntu thread?