Postgres Pro
Downloads
Home   >   mailing lists

Re: PGAdmin: type geography does not exist - Mailing list pgadmin-support

From Ashesh Vashi
Subject Re: PGAdmin: type geography does not exist
Date
Msg-id CAG7mmowj+HhRA=MPLLZFribG1p181yE_n2PacMjE98pjs6PqJg@mail.gmail.com
Whole thread Raw
In response to PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
Responses Re: PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
List pgadmin-support
Tree view
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.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 3:46 PM Tony Shelver <tshelver@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?

pgadmin-support by date:

Previous
From: Tony Shelver
Date:
Subject: PGAdmin: type geography does not exist
Next
From: Tony Shelver
Date:
Subject: Re: PGAdmin: type geography does not exist