Postgres Pro
Downloads
Home   >   mailing lists

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

From Tony Shelver
Subject PGAdmin: type geography does not exist
Date
Msg-id CAG0dhZDdPwhJSSgk_cfzAgx+Simmw_ex_Tw4Hy0xHvLDLmiDRA@mail.gmail.com
Whole thread Raw
Responses Re: PGAdmin: type geography does not exist  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-support
Tree view
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: Dave Page
Date:
Subject: Re: import upload file to pgadmin get CSRF error
Next
From: Ashesh Vashi
Date:
Subject: Re: PGAdmin: type geography does not exist