BUG #13652: Function names as a table prefiex by underscore, confused with array

From: marisradu(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13652: Function names as a table prefiex by underscore, confused with array
Date: 2015-09-29 13:19:42
Message-ID: 20150929131942.1414.58542@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: 13652
Logged by: Maris Radu
Email address: marisradu(at)gmail(dot)com
PostgreSQL version: 9.4.4
Operating system: Ubuntu Server 14.04.1
Description:

Creating a method "_c()" as:
create or replace function _c(text) returns text as $$
select $1;
$$ language sql immutable;

and a table "c" as:
create table c (id int);

Select by _c(text) returns unexpected error:

# select _c('text');
ERROR: malformed array literal: "text"
LINE 1: select _c('text');
^
DETAIL: Array value must start with "{" or dimension information.

Dropping the table or renaming the function to solves the issue.

Expecting: The query to run normally, or an error when creating the function
or the table if the function was defined first.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-09-29 14:55:20 Re: BUG #13638: Exception texts from plperl has bad encoding
Previous Message Tom Lane 2015-09-29 13:13:46 Re: BUG #13649: system catalog pg_authid doesn't update automatically