Hi! This is a first for me. When creating a new table on one Firebird 2.5 installation, I am getting the following error:
ISC ERROR CODE:335544351 ISC ERROR MESSAGE: unsuccessful metadata update request depth exceeded. (Recursive definition?) Statement: CREATE TABLE v9karty_log ( v9_klic TID NOT NULL, v9_vytvoril TID, v9_vytvoril_kdy TDATETIME, v9_zmenil TID, v9_zmenil_kdy TDATETIME, v9_stav TSTAV, v9_zrusil TBOOLEAN, v9_typ TCHAR, v9_datum TDATETIME, v9_id_karty TID, v9_id_expedice TID, v9_osoba TID, v9_stanice TID, v9_pobocka TTEXT5, v9_zmena_bodu TCENA, v9_zmena_slevy TCENA, v9_poskytnuta_sleva TCENA, v9_body_bef TCENA, v9_sleva_bef TCENA, v9_body_aft TCENA, v9_sleva_aft TCENA, CONSTRAINT pk_v9kartylog PRIMARY KEY (v9_klic) ) Search through Google revealed that this error might happen if a) Too many metadata updates occured without a backup/restore cycle. This is unlikely in this case, but I will perform a backup/restore just to be certain. b) There really is a recursive element in my query. But if this is the case, I just don't see it - there is certainly nothing in the CREATE TABLE itself, and as the database doesn't use foreign keys at all, I would also rule out recursive cascades. c) CORE-3763. But I don't use computed_by indexes. What else could possibly be the problem? Thanks, Josef ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/