Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Bugs > BUG #4147: pg_c...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3750 of 3899
Post > Topic >>

BUG #4147: pg_constraint table data retrieval error

by arun.jaganathan@[EMAIL PROTECTED] ("Arun J M") May 6, 2008 at 11:00 AM

The following bug has been logged online:

Bug reference:      4147
Logged by:          Arun J M
Email address:      arun.jaganathan@[EMAIL PROTECTED]
 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.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
 




 1 Posts in Topic:
BUG #4147: pg_constraint table data retrieval error
arun.jaganathan@[EMAIL PR  2008-05-06 11:00:12 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:58:14 CDT 2008.