ID: 19915 Updated by: [EMAIL PROTECTED] Reported By: irie at gmx dot de -Status: Open +Status: Closed Bug Type: InterBase related Operating System: Linux 2.4.18 PHP Version: 4.3.0-pre1 New Comment:
Because InterBase uses a transaction to process the metadata updates, the dependency conflict is not reported before the is transaction is committed. Previous Comments: ------------------------------------------------------------------------ [2002-10-15 05:43:02] irie at gmx dot de Hi, dropping a table fails in interbase if there are existing dependensies for the table, i.e. if a view is using the table. Executing such a query with the isql tool I get: SQL> DROP TABLE SONGS; Statement failed, SQLCODE = -607 unsuccessful metadata update -cannot delete -COLUMN ARTIST -there are 1 dependencies But executing the same query via php's ibase_query() returns TRUE : var_dump(ibase_query($dbhandle, 'DROP TABLE SONGS')); > bool(true) Beside 4.3.0-pre1 I've just tested this with 4.0.6 and found the same behavior. Lutz ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19915&edit=1
