Thread: OF TYPE without SCHEMA specified in TABLE creation interface

OF TYPE without SCHEMA specified in TABLE creation interface

From
"liuyuanyuan"
Date:

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

 

Attachment

OF TYPE without SCHEMA specified in TABLE creation interface

From
"liuyuanyuan"
Date:

 

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

 

Attachment
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@gmail.com> 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

 


Attachment

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:sanket.mehta@enterprisedb.com]
发送时间: 2014825 16:34
收件人: Ashesh Vashi
抄送: pgsql-admin@postgresql.org; 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 <ashesh.vashi@enterprisedb.com> 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@gmail.com> 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

 

 

 

Attachment

Re: OF TYPE without SCHEMA specified in TABLE creation interface

From
Sanket Mehta
Date:
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@enterprisedb.com> 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@enterprisedb.com> 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@gmail.com> 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

 




Attachment