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: 2008-05-06 11:00:12
Message-ID: 200805061100.m46B0CSG045982@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2008-05-07 04:12:36 Re: [BUGS] BUG #3975: tsearch2 index should not bomb out of 1Mb limit
Previous Message Simon Riggs 2008-05-06 08:12:48 Re: BUG #4137: Postgres drives pg_standby %r param to delete WAL file before processing