OF TYPE without SCHEMA specified in TABLE creation interface

From: "liuyuanyuan" <liuyuanyuangogo(at)gmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>, <pgadmin-hackers(at)postgresql(dot)org>
Cc: "'Guillaume Lelarge'" <guillaume(at)lelarge(dot)info>
Subject: OF TYPE without SCHEMA specified in TABLE creation interface
Date: 2014-08-20 01:57:16
Message-ID: 000201cfbc1a$164a66a0$42df33e0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-admin

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

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2014-08-21 08:55:06 Re: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
Previous Message liuyuanyuan 2014-08-18 04:02:07 OF TYPE without SCHEMA specified in TABLE creation interface

Browse pgsql-admin by date

  From Date Subject
Next Message Raghu Ram 2014-08-20 03:34:37 Re: Upgrading PostgreSQL from v8.4.14 to v9.3.5
Previous Message Ashish Yadav 2014-08-18 21:16:40 Upgrading PostgreSQL from v8.4.14 to v9.3.5