Re: OF TYPE without SCHEMA specified in TABLE creation interface

Hi,

I have tried to reproduce the same scenario in Ubuntu 14.04 64 bit where
PEM version: 4.0.1
Db server: PostGRESql 9.3
I did not get any error while creating the table using step 2 mentioned in
below mail.

Please do provide below information regarding environment in which the bug
has occurred.
So that i can help track down the issue.

- OS name and version
- PEM version / PG admin version
- DB server name and version

Regards,
Sanket Mehta

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Thu, Aug 21, 2014 at 2:25 PM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:

> Hi Sanket,
>
> Can you please take a look at this?
>
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com>
>
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <http://www.linkedin.com/in/asheshvashi>
>
>
> On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <liuyuanyuangogo(at)gmail(dot)com>
> wrote:
>
>>
>>
>> Hi!
>>
>> I got a problem when I create a table of type by table creation interface
>> of pgadmin.
>>
>> Because OF TYPE without SCHEMA specified, the table creation failed.
>>
>> I think the type should have schema specified when its schema being not
>> ‘public’, please check.
>>
>> A example as follow
>>
>> First step:
>>
>> CREATE TYPE test.person AS
>>
>> (
>>
>> id integer,
>>
>> name character varying COLLATE pg_catalog."POSIX"
>>
>> );
>>
>>
>>
>> Second step:
>>
>>
>>
>> type has no schema specified :
>>
>>
>>
>> Then I click button OK, it got error as follow:
>>
>>
>>
>> At last, I add schema to type, then successfully:
>>
>>
>>
>> CREATE TABLE test.test
>>
>> OF *test*.person
>>
>> WITH (
>>
>> OIDS = FALSE
>>
>> );
>>
>>
>>
>>
>>
>> Best regard!
>>
>> Yours,
>>
>> Jasmine
>>
>>
>>
>
>