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.
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 |