create type error message

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: create type error message
Date: 2006-03-23 00:03:56
Message-ID: 20060322235902.M83205@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


# select version();
version
--------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
(1 row)

simple example:
# create type a as (a text,b int);
CREATE TYPE
# create type a as (a text,b int);
ERROR: relation "a" already exists

seems like

ERROR: type "a" already exists
would be better.

Thanks
Jim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2006-03-23 00:09:09 Where does the time go?
Previous Message Tom Lane 2006-03-22 23:48:37 Re: Accessing schema data in information schema