Re: OF TYPE without SCHEMA specified in TABLE creation interface

Hi All,

In last mail by mistake its PEM vesion is mentioned.

please note It is pgAdmin version 1.18.1 not PEM.

Regards,
Sanket

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Aug 25, 2014 at 2:04 PM, Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com
> wrote:

> 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
>>>
>>>
>>>
>>
>>
>