Skip site navigation (1) Skip section navigation (2)

User-defined type name begins with the underscore character (_) can be created

From: Pavel Golub <pavel(at)microolap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: User-defined type name begins with the underscore character (_) can be created
Date: 2006-12-12 08:44:13
Message-ID: 1679003548.20061212104413@microolap.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello, pgsql-bugs.

Documentation says:
"User-defined type names cannot begin with the
underscore character (_) and can only be 62
characters long (or in general NAMEDATALEN - 2,
rather than the NAMEDATALEN - 1 characters
allowed for other names). Type names beginning
with underscore are reserved for
internally-created array type names. "

However, such SQL may be executed:

CREATE TYPE _my AS (id int4, id2 int4);

And server treats it as array type. Thus next SQL will be executed too:

CREATE TABLE my_table(
my_arr my[]
);

Checked on PostgreSQL versions (Windows XP):
8.0.6
8.1.0
8.2.0

-- 
With best wishes,
 Pavel                          mailto:pavel(at)microolap(dot)com


Responses

pgsql-bugs by date

Next:From: Dave PageDate: 2006-12-12 09:24:30
Subject: 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches pgAdmin)
Previous:From: J. Greg DavidsonDate: 2006-12-12 05:33:34
Subject: SPI_getvalue calls output function w/o pushing existing SPIconnection + 2 extra issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group