Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.0b4
Request #10215 listtableconstraints dont list check constraints
Submitted: 2007-02-28 10:34 UTC
From: albatista at gmail dot com Assigned: quipo
Status: Closed Package: MDB2_Driver_oci8 (version 1.3.0)
PHP Version: 5.1.4 OS: Debian
Roadmaps: (Not assigned)    
Subscription  


 [2007-02-28 10:34 UTC] albatista at gmail dot com (wistoka)
Description: ------------ The function listTableConstraints gets a list of the constraints of a table getting the entries in USER_CONSTRAINT oracle table with the SQL 'SELECT index_name name FROM user_constraints WHERE table_name='foo' OR table_name='FOO' buts some constraints (check constraint) have the index_name field empty so the function don't get them. I wonder if its better to get the field constraint_name instead of index_name in the query, resulting the query 'SELECT constraint_name name FROM user_constraints WHERE table_name='foo' OR table_name='FOO'. I'm programming with php Oracle 10 XE and Oracle Zend Core 2.1.0 (php 5.1.4)

Comments

 [2007-03-01 13:48 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!