Re: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface

[Sanket Mehta <sanket.mehta@xxxxxxxxxxxxxxxx>]

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.mehta@xxxxxxxxxxxxxxxx> 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.vashi@xxxxxxxxxxxxxxxx> wrote:

Hi Sanket,

Can you please take a look at this?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi

On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <liuyuanyuangogo@xxxxxxxxx> 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