BUG #2016: query working with 8.0 fails with 8.1
The following bug has been logged online:
Bug reference: 2016
Logged by: Pit Mueller
Email address: fmi-soft@gmx.de
PostgreSQL version: 8.1 BETA4
Operating system: WinXP
Description: query working with 8.0 fails with 8.1
Details:
Using this query to get the primary key for a certain table:
SELECT p.conname AS constraint_name FROM pg_constraint p WHERE p.contype =
'p' AND p.conrelid = pg_class.oid AND pg_class.relname = 'mytablename'
leads to an error:
ERROR: missing FROM-clause entry for table "pg_class"
This query worked fine with 8.0.3.
Pit Mueller wrote:
SELECT p.conname AS constraint_name FROM pg_constraint p WHERE
p.contype = 'p' AND p.conrelid = pg_class.oid AND pg_class.relname =
'mytablename'leads to an error:
ERROR: missing FROM-clause entry for table "pg_class"
You need to mention pg_class in the FROM clause.
This query worked fine with 8.0.3.
The query was always incorrect, and 8.1 is now stricter in that regard.
To get bugward-compatible behavior, look up the configuration parameter
add_missing_from.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/