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] quipo (Lorenzo Alberton)
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.