From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: pgadmin-hackers@postgresql.org
To: pgsql-admin@postgresql.org
Cc: 'Sanket Mehta' <sanket.mehta@enterprisedb.com>
Subject: 答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
Date: Mon, 25 Aug 2014 16:57:03 +0800
Message-ID: <006f01cfc042$90e5d670$b2b18350$@gmail.com> (raw)
In-Reply-To: <CA+yw=mOWMWUtGAaD+ASESEWs6nT1kHfBBp7ZQZ0_RwxYOBJtrQ@mail.gmail.com>
References: <008601cfba99$31264cf0$9372e6d0$@gmail.com>
<000201cfbc1a$164a66a0$42df33e0$@gmail.com>
<CAG7mmozJeT7QE8Tazwz8QAgytXfk4HO+g3C3QuKX8VWmf36XrQ@mail.gmail.com>
<CA+yw=mOWMWUtGAaD+ASESEWs6nT1kHfBBp7ZQZ0_RwxYOBJtrQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Thanks for your reply!
The environment is：
PgadminIII:1.18.1
Db: PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 64-bit
Os:win7
Regards!
Jasmine
发件人: Sanket Mehta [mailto:sanket.mehta@enterprisedb.com]
发送时间: 2014年8月25日 16:34
收件人: Ashesh Vashi
抄送: pgsql-admin@postgresql.org; pgadmin-hackers; Guillaume Lelarge; liuyuanyuan
主题: Re: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
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 <mailto: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.enterprisedb.com;
<http://www.linkedin.com/in/asheshvashi; http://www.linkedin.com/in/asheshvashi
<http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285751372076&u=4060523&e=777;
On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <liuyuanyuangogo@gmail.com <mailto: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
Attachments:image001.jpg (image/jpeg, 16.6K) downloadview imageimage002.jpg (image/jpeg, 15.2K) downloadview imageimage003.jpg (image/jpeg, 14.6K) downloadview imageimage004.jpg (image/jpeg, 42.5K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: liuyuanyuangogo@gmail.com, pgadmin-hackers@postgresql.org, sanket.mehta@enterprisedb.com
Subject: Re: 答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
In-Reply-To: <006f01cfc042$90e5d670$b2b18350$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox