Function quote_literal broken in CATALOG_VERSION_NO 200707251

Started by Jignesh K. Shahover 18 years ago2 messages
#1Jignesh K. Shah
J.K.Shah@Sun.COM

Just FYI:

I took the latest snapshot CATALOG_VERSION_NO 200707251 and function
quote_literal throws an error:

# select quote_literal(1);
2007-08-20 18:50:17 PDT ERROR: function quote_literal(integer) does not
exist at character 8
2007-08-20 18:50:17 PDT HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2007-08-20 18:50:17 PDT STATEMENT: select quote_literal(1);
ERROR: function quote_literal(integer) does not exist
LINE 1: select quote_literal(1);

I went back to an older snapshot CATALOG_VERSION_NO 200705211 and it
works with the same SunStudio compiler and options:

postgres=# select quote_literal(1);
quote_literal
---------------
'1'
(1 row)

-Jignesh

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jignesh K. Shah (#1)
Re: Function quote_literal broken in CATALOG_VERSION_NO 200707251

"Jignesh K. Shah" <J.K.Shah@Sun.COM> writes:

# select quote_literal(1);
2007-08-20 18:50:17 PDT ERROR: function quote_literal(integer) does not
exist at character 8

quote_literal(integer) never existed in any previous release, either.

What you are seeing is a side effect of the removal of implicit casts to
text. IMHO rejecting this query is a good thing.

regards, tom lane