Re: PGAdmin: type geography does not exist

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Re: PGAdmin: type geography does not exist
Дата
Msg-id CAG7mmowj+HhRA=MPLLZFribG1p181yE_n2PacMjE98pjs6PqJg@mail.gmail.com
обсуждение исходный текст
Ответ на PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
Ответы Re: PGAdmin: type geography does not exist
Список 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.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 по дате отправления: