Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group