Re: PGAdmin: type geography does not exist
| От | Tony Shelver |
|---|---|
| Тема | Re: PGAdmin: type geography does not exist |
| Дата | |
| Msg-id | CAG0dhZC5pJDDmDq2B58dHVztxEqQTNn7GafqP_JARKKQNKaaJQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PGAdmin: type geography does not exist (Ashesh Vashi <ashesh.vashi@enterprisedb.com>) |
| Список | pgadmin-support |
On Tue, 6 Aug 2019 at 14:32, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
If you're running from the sql editor, then - you have either of the two options:Set search_path = 'teleon, public';CREATE TABLE...Or,Specify the schema in front of tge type.-- Thanks, AsheshWill have a go at it. However, for those of us less pg-aware folks, it seems strange that running the script in psql works versus in pgdmin4. As far as i know, this worked on a prior pgAdmin4 release when I was running on Windows 10, not Ubuntu.
Will have a go at it. However, for those of us less pg-aware folks, it seems strange that running the script in psql works versus in pgdmin4. As far as i know, this worked on a prior pgAdmin4 release when I was running on Windows 10, not Ubuntu.
It also works fine if I execute the same scripts from within pgmodeler (which is where I cut the source from originally).
I am a bit wary about setting the path, I have multiple schemas.
Not a biggie for me at the moment, it was just a quick fix to test things out prior to doing a full pgmodeler DB rebuild and reload.
В списке pgadmin-support по дате отправления: