On Wed, May 4, 2016 at 9:58 AM, Marc Mamin <M.Mamin@intershop.de> wrote:
> This query is working in 9.4.x, but not in 9.5.2:
>
> select 'x' sql;
>
> ERROR: syntax error at or near "sql"
> LINE 1: select 'x' sql;
>
> Is this expected or a known issue?
> I could neither find any hint about it in the incompatibility list of the
> 9.5 release notes,
> nor is "sql" listed as reserved keyword.
Sadly, that fails for ANY keyword, not just reserved keywords.
EnterpriseDB has gotten a few customer complaints about this, but it's
not obvious how to fix it.
This commit made SQL a keyword:
commit cac76582053ef8ea07df65fed0757f352da23705
Author: Peter Eisentraut <peter_e@gmx.net>
Date: Sun Apr 26 10:33:14 2015 -0400
Add transforms feature
This provides a mechanism for specifying conversions between SQL data types and procedural languages. As
examples,there are transforms for hstore and ltree for PL/Perl and PL/Python.
reviews by Pavel Stěhule and Andres Freund
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company