Re: BUG #2016: query working with 8.0 fails with 8.1

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/