Re: PGAdmin: type geography does not exist

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 <[email protected]> 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?
>