BUG #4147: pg_constraint table data retrieval error
- From: "Arun J M" <arun(dot)jaganathan(at)alliedgroups(dot)com>
- To: pgsql-bugs(at)postgresql(dot)org
- Subject: BUG #4147: pg_constraint table data retrieval error
- Date: Tue, 6 May 2008 11:00:12 GMT
- Message-id: <200805061100(dot)m46B0CSG045982(at)wwwmaster(dot)postgresql(dot)org>
The following bug has been logged online:
Bug reference: 4147
Logged by: Arun J M
Email address: arun(dot)jaganathan(at)alliedgroups(dot)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.
Home |
Main Index |
Thread Index