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.
