OF TYPE without SCHEMA specified in TABLE creation interface

From: "liuyuanyuan" <liuyuanyuangogo(at)gmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: OF TYPE without SCHEMA specified in TABLE creation interface
Date: 2014-08-18 04:02:07
Message-ID: 008601cfba99$31264cf0$9372e6d0$@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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message liuyuanyuan 2014-08-20 01:57:16 OF TYPE without SCHEMA specified in TABLE creation interface
Previous Message yanhong ma 2014-08-18 02:04:26 zh_CN Chinese simplified pgadmin3

Browse pgsql-admin by date

  From Date Subject
Next Message Nagy László Zsolt 2014-08-18 18:21:37 sum, min, max and null
Previous Message Matheus de Oliveira 2014-08-15 18:35:53 Re: pg_upgrade with C-language extensions?