On Wed, May 4, 2016 at 9:58 AM, Marc Mamin <m.ma...@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 <pete...@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

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to