pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: pgsql-admin@postgresql.org
To: pgadmin-hackers@postgresql.org
Cc: 'Guillaume Lelarge' <guillaume@lelarge.info>
Subject: OF TYPE without SCHEMA specified in TABLE creation interface
Date: Wed, 20 Aug 2014 09:57:16 +0800
Message-ID: <000201cfbc1a$164a66a0$42df33e0$@gmail.com> (raw)
In-Reply-To: <008601cfba99$31264cf0$9372e6d0$@gmail.com>
References: <008601cfba99$31264cf0$9372e6d0$@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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

view thread (5+ messages)  latest in thread

Message-ID: <000201cfbc1a$164a66a0$42df33e0$@gmail.com>
Permalink:  ../000201cfbc1a$164a66a0$42df33e0$@gmail.com/
Also on:    postgresql.org/message-id/000201cfbc1a$164a66a0$42df33e0$@gmail.com

copy link · copy postgr.es

reply

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, guillaume@lelarge.info
  Subject: Re: OF TYPE without SCHEMA specified in TABLE creation interface
  In-Reply-To: <000201cfbc1a$164a66a0$42df33e0$@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