From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Tony Shelver <tshelver(at)gmail(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PGAdmin: type geography does not exist |
Date: | 2019-08-06 10:18:41 |
Message-ID: | CAG7mmowj+HhRA=MPLLZFribG1p181yE_n2PacMjE98pjs6PqJg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 <tshelver(at)gmail(dot)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?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Shelver | 2019-08-06 10:32:24 | Re: PGAdmin: type geography does not exist |
Previous Message | Tony Shelver | 2019-08-06 10:16:04 | PGAdmin: type geography does not exist |