BUG #13053: type names pollute function name space

From: dwayne(dot)towell(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13053: type names pollute function name space
Date: 2015-04-14 21:24:54
Message-ID: 20150414212454.5205.74148@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13053
Logged by: Dwayne Towell
Email address: dwayne(dot)towell(at)gmail(dot)com
PostgreSQL version: 9.2.10
Operating system: CentOS
Description:

The following:

CREATE TYPE x AS (id int);
CREATE FUNCTION _x(text) RETURNS SETOF x AS $$ SELECT 1 WHERE $1='hi'; $$
LANGUAGE SQL;
SELECT _x('hi');

produces:

ERROR: array value must start with "{" or dimension information
LINE 1: SELECT _x('hi');

Which seems wrong. Creating a type named 'x' should not preempt my function
by finding an auto created(?) conversion(?) function.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2015-04-14 22:54:38 Re: BUG #13053: type names pollute function name space
Previous Message Michael Paquier 2015-04-13 23:14:18 Re: BUG #13010: After promote postgres try to send old timeline WALs to archive