答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface - Mailing list pgadmin-hackers

From liuyuanyuan
Subject 答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
Date
Msg-id 006f01cfc042$90e5d670$b2b18350$@gmail.com
Whole thread Raw
In response to Re: OF TYPE without SCHEMA specified in TABLE creation interface  (Sanket Mehta <sanket.mehta@enterprisedb.com>)
List pgadmin-hackers

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

pgadmin-hackers by date:

Previous
From: Sanket Mehta
Date:
Subject: Re: OF TYPE without SCHEMA specified in TABLE creation interface
Next
From: Timon
Date:
Subject: Fwd: Russian translation for upcoming release