Re: Dropping Temp Tables (OnLine)

Posted in 1995

Kerry Sainsbury — Fri, 01 Dec 1995 21:47:59 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <30ba9e00.12959443@news3.cts.com>, dwolt@cts.com (Dave Woltkamp) wrote: >There have been a few messages posted here regarding the dropping of >temp tables. We have many programs that drop temp tables and are >currently using SE v5.1. We are about to convert to OnLine 7.1 and >I'm wondering if dropping temp tables will cause us any headaches? It causes us headaches in 6.x SE. We often get 'Table already exists' errors if we try to re-create the TEMP table after the drop. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html