pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOF TYPE without SCHEMA specified in TABLE creation interface
5+ messages / 3 participants
[nested] [flat]
* OF TYPE without SCHEMA specified in TABLE creation interface
@ 2014-08-18 04:02 liuyuanyuan <liuyuanyuangogo@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: liuyuanyuan @ 2014-08-18 04:02 UTC (permalink / raw)
To: 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
Attachments:
image007.jpg (image/jpeg, 42.5K) download
view image
image002.jpg (image/jpeg, 16.6K) download
view image
image004.jpg (image/jpeg, 15.2K) download
view image
image006.jpg (image/jpeg, 14.6K) download
view image
* OF TYPE without SCHEMA specified in TABLE creation interface
@ 2014-08-20 01:57 liuyuanyuan <liuyuanyuangogo@gmail.com>
parent: liuyuanyuan <liuyuanyuangogo@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: liuyuanyuan @ 2014-08-20 01:57 UTC (permalink / raw)
To: pgsql-admin; pgadmin-hackers@postgresql.org; +Cc: 'Guillaume Lelarge' <guillaume@lelarge.info>
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:
image007.jpg (image/jpeg, 42.5K) download
view image
image002.jpg (image/jpeg, 16.6K) download
view image
image004.jpg (image/jpeg, 15.2K) download
view image
image006.jpg (image/jpeg, 14.6K) download
view image
* Re: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface
@ 2014-08-21 08:55 Ashesh Vashi <ashesh.vashi@enterprisedb.com>
parent: liuyuanyuan <liuyuanyuangogo@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Ashesh Vashi @ 2014-08-21 08:55 UTC (permalink / raw)
To: Sanket Mehta <sanket.mehta@enterprisedb.com>; +Cc: pgsql-admin@postgresql.org, pgadmin-hackers <pgadmin-hackers@postgresql.org>; Guillaume Lelarge <guillaume@lelarge.info>; liuyuanyuan <liuyuanyuangogo@gmail.com>
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;
On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <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:
image006.jpg (image/jpeg, 14.6K) download
view image
image004.jpg (image/jpeg, 15.2K) download
view image
image007.jpg (image/jpeg, 42.5K) download
view image
image002.jpg (image/jpeg, 16.6K) download
view image
* Re: OF TYPE without SCHEMA specified in TABLE creation interface
@ 2014-08-25 08:34 Sanket Mehta <sanket.mehta@enterprisedb.com>
parent: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: Sanket Mehta @ 2014-08-25 08:34 UTC (permalink / raw)
To: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; +Cc: pgsql-admin@postgresql.org, pgadmin-hackers <pgadmin-hackers@postgresql.org>; Guillaume Lelarge <guillaume@lelarge.info>; liuyuanyuan <liuyuanyuangogo@gmail.com>
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
> 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;
>
>
> On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <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:
image004.jpg (image/jpeg, 15.2K) download
view image
image007.jpg (image/jpeg, 42.5K) download
view image
image002.jpg (image/jpeg, 16.6K) download
view image
image006.jpg (image/jpeg, 14.6K) download
view image
* Re: OF TYPE without SCHEMA specified in TABLE creation interface
@ 2014-08-25 08:40 Sanket Mehta <sanket.mehta@enterprisedb.com>
parent: Sanket Mehta <sanket.mehta@enterprisedb.com>
0 siblings, 0 replies; 5+ messages in thread
From: Sanket Mehta @ 2014-08-25 08:40 UTC (permalink / raw)
To: Ashesh Vashi <ashesh.vashi@enterprisedb.com>; +Cc: pgsql-admin@postgresql.org, pgadmin-hackers <pgadmin-hackers@postgresql.org>; Guillaume Lelarge <guillaume@lelarge.info>; liuyuanyuan <liuyuanyuangogo@gmail.com>
Hi All,
In last mail by mistake its PEM vesion is mentioned.
please note It is pgAdmin version 1.18.1 not PEM.
Regards,
Sanket
Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb
On Mon, Aug 25, 2014 at 2:04 PM, Sanket Mehta <sanket.mehta@enterprisedb.com
> wrote:
> 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> 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;
>>
>>
>> On Wed, Aug 20, 2014 at 7:27 AM, liuyuanyuan <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:
image002.jpg (image/jpeg, 16.6K) download
view image
image004.jpg (image/jpeg, 15.2K) download
view image
image007.jpg (image/jpeg, 42.5K) download
view image
image006.jpg (image/jpeg, 14.6K) download
view image
end of thread, other threads:[~2014-08-25 08:40 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-08-18 04:02 OF TYPE without SCHEMA specified in TABLE creation interface liuyuanyuan <liuyuanyuangogo@gmail.com>
2014-08-20 01:57 ` liuyuanyuan <liuyuanyuangogo@gmail.com>
2014-08-21 08:55 ` Ashesh Vashi <ashesh.vashi@enterprisedb.com>
2014-08-25 08:34 ` Sanket Mehta <sanket.mehta@enterprisedb.com>
2014-08-25 08:40 ` Sanket Mehta <sanket.mehta@enterprisedb.com>
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