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 <[email protected] > 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 <[email protected]> > 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 >> >> >> > >
