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 clau
The following bug has been logged online:
Bug reference: 2016
Logged by: Pit Mueller
Email address: [EMAIL PROTECTED]
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
