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