Thanks for your reply!
The environment is： PgadminIII:1.18.1 Db: PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 64-bit Os:win7 Regards! Jasmine 发件人: Sanket Mehta [mailto:[email protected]] 发送时间: 2014年8月25日 16:34 收件人: Ashesh Vashi 抄送: [email protected]; pgadmin-hackers; Guillaume Lelarge; liuyuanyuan 主题: Re: [pgadmin-hackers] 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 <[email protected] <mailto:[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 <http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285751372076&u=4060523&e=777> On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <[email protected] <mailto:[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
