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.
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 |