Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9R0ZxP53563 for ; Fri, 26 Oct 2001 20:35:59 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f9R0OJZ49087 for pgsql-sql@postgresql.org; Fri, 26 Oct 2001 20:24:19 -0400 (EDT) (envelope-from news) From: "Jack" X-Newsgroups: comp.databases.postgresql.sql Subject: Problems of Temporary table Date: Sat, 27 Oct 2001 10:18:12 +1000 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 15 Message-ID: <9rcuri$1fts$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 To: pgsql-sql@postgresql.org X-Archive-Number: 200110/391 X-Sequence-Number: 5343 HI, all Temporary tables created by "CREATE TABLE" or by "SELECT ..INTO" are so hard to handle. If it doesn't exist, then "drop" cuases an error. If the same procedure runs second time without dropping all temporary tables, providing still in the same connection session, then procedure causes "table exists" error. And it's unable to search system table to find whether it exists or not. Is that possible to have a command like "drop table if exist"? Please provide advices, thank you! JACK