Can you please let me know the output of 'SHOW search_path' from the psql? --
Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> On Tue, Aug 6, 2019 at 3:46 PM Tony Shelver <tshel...@gmail.com> wrote: > 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? >
