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

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: (view raw, whole thread or download thread mbox)
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

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:


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.

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group