From: | Daniel Begin <jfd553(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Inconsistency between PgAdmin III GUI and SQL window ? |
Date: | 2014-10-21 22:33:02 |
Message-ID: | COL129-DS27498874E82CE8C7835C8194940@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have first to admit the inconsistency is probably on my side!-)
The task - I want to clone a table I created in public schema in another
schema (xxx) of the same database.
The problem - I get an error message when creating the table using the
original SQL script: ERROR: type "geography" does not exist.
I understand from
"http://stackoverflow.com/questions/9067335/how-to-create-table-inside-speci
fic-schema-by-default-in-postgres" that the original script should work if I
set the search path to the destination schema (xxx) prior to execute the
script (set search_path to xxx ;) but the PgAdmin III SQL window does not
seem aware of the geography type.
What I do not understand is that using the GUI (contextual menu. new table .
new column.) within schema xxx, I can create the table as expected, and the
geography type is recognized. Any idea about what is going on when using
the SQL window?
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-10-21 22:56:16 | Re: Inconsistency between PgAdmin III GUI and SQL window ? |
Previous Message | TigerNassau | 2014-10-21 14:49:48 | Re: Yosemite (OSX 10.0) problems with Postgresql |