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