Re: PGAdmin: type geography does not exist

On Tue, 6 Aug 2019 at 14:32, Ashesh Vashi <[email protected]>
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, Ashesh
>
>
> 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.
>


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.