-710 - bouncy bouncy...

} } ----- Transcript of session follows ----- } Connected to mica.inel.gov: } >>> HELO mica } <<< 553 mica host name configuration error } 554 <daveb@pmafire.inel.gov>... Service unavailable } } ----- Unsent message follows ----- } Return-Path: <jparker@hpbs3645.boi.hp.com> } Received: from hp.com by mica } (4.1/INEL-MH-10.0) id AA00775; Mon, 15 Aug 94 09:51:14 MDT } Received: from hpbs3645.boi.hp.com by hp.com with SMTP } (1.36.108.7/15.5+IOS 3.13) id AA21401; Mon, 15 Aug 1994 08:51:13 -0700 } Received: by hpbs3645.boi.hp.com } (1.37.109.4/15.5+IOS 3.22) id AA22794; Mon, 15 Aug 94 09:56:05 -0600 } From: Jack Parker <jparker@hpbs3645.boi.hp.com> } Message-Id: <9408151556.AA22794@hpbs3645.boi.hp.com> } Subject: -710 } To: daveb@pmafire.inel.gov } Date: Mon, 15 Aug 94 9:56:05 MDT } Mailer: Elm [revision: 70.85] } } > > } > } > I excitedly tried your suggestion, as it seemed like such a logical } > solution. Unfortunately, it did not change my result at all. It still } > seems, however, that you may at least be close to where this bug lives. } > I hope the Informix boys and girls take a look at this someday. } > } > Thanks for taking time to respond. } } Which made me realize the answer..... (actually another guess, but more } sensible) } } CREATE TEMP TABLE kjhkjhkjkj WITH NO LOG } ^^^^^^^^^^^ } } Since schema statements are logged, WHETHER OR NOT YOU HAVE LOGGING TURNED ON, } the transaction is out there saying the table still exists after you drop } it. } } j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| He who talks most, talks least. jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________