am Wed, dem 17.01.2007, um 16:04:10 +0000 mailte David Goodenough folgendes: > I have a servlet which gets its data through a DataSource (Tomcat 5.5) > and starts each request as a new SQL transaction and either commits > the transaction or rolls it back at the end of each request. > > In one of the requests I do a SELECT ... INTO TEMPORARY t1 ..., which > works just fine when I first use it, but from then on it objects saying > that t1 already exists. When I read the documentation (8.1 as that is > what I am using) I thought I understood that the table would disappear > at the end of the transaction. Other than deleting it, is there something > else I need to do or have I missunderstood that into temporary does?
known problem, FAQ. Use EXECUTE for your DDL-Statements. http://www.postgresql.org/docs/faqs.FAQ.html#item4.19 Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
