BUG #4147: pg_constraint table data retrieval error - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4147
Logged by:          Arun J M
Email address:      arun.jaganathan@alliedgroups.com
PostgreSQL version: 8.3
Operating system:   Windows XP Pro SP2
Description:        pg_constraint table data retrieval error
Details:

While we are retrieving the values from the Pg_constraint table using the
confkey column as mentioned below the query returns the null value, But it
should return the appropriate value from the small int array..

Executed Query:

select pg_constraint.confkey[1] from pg_catalog.pg_constraint

Expected Result:

{1}
{111}
{444}

Result Obtained:

Null values


This is not working on pgadmin/sql , psql , phpadmin/sql.

But the same query is working while executing from php code.