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