PGAdmin: type geography does not exist

From: Tony Shelver <tshelver(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: PGAdmin: type geography does not exist
Date: 2019-08-06 10:16:04
Message-ID: CAG0dhZDdPwhJSSgk_cfzAgx+Simmw_ex_Tw4Hy0xHvLDLmiDRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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?

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2019-08-06 10:18:41 Re: PGAdmin: type geography does not exist
Previous Message Dave Page 2019-08-06 08:02:02 Re: import upload file to pgadmin get CSRF error