Re: OF TYPE without SCHEMA specified in TABLE creation interface

Поиск

Список

Период

Сортировка

От	Sanket Mehta
Тема	Re: OF TYPE without SCHEMA specified in TABLE creation interface
Дата	25 августа 2014 г. 11:39:35
Msg-id	CA+yw=mOWMWUtGAaD+ASESEWs6nT1kHfBBp7ZQZ0_RwxYOBJtrQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Ответы	Re: OF TYPE without SCHEMA specified in TABLE creation interface 答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
Список	pgadmin-hackers

Дерево обсуждения

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