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
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 |
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 |