Received: from druid.net (druid.net [216.126.72.98]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2OCgjw44777 for ; Sat, 24 Mar 2001 07:42:51 -0500 (EST) (envelope-from darcy@druid.net) Received: by druid.net (Postfix, from userid 1000) id A94771A61; Sat, 24 Mar 2001 07:42:15 -0500 (EST) Subject: Re: how do I check if a temporary table exists? In-Reply-To: <005f01c0b41c$eb801e60$2400a8c0@hnjack> "from datactrl at Mar 24, 2001 02:43:04 pm" To: datactrl Date: Sat, 24 Mar 2001 07:42:15 -0500 (EST) Cc: pgsql-sql@postgresql.org, roelof.sondaar@scania.com X-Mailer: ELM [version 2.4ME+ PL78 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Message-Id: <20010324124215.A94771A61@druid.net> From: darcy@druid.net (D'Arcy J.M. Cain) X-Archive-Number: 200103/476 X-Sequence-Number: 2145 Thus spake datactrl > How do I check if a temporary table exists? Searching pg_tables with a > temporary table name we chose always fails. What do you mean? You know that it exists because you just created it and the create succeeded. Can you describe a situation where you need to know about a temp table and don't already know? It can't go into the pg_tables table because then it would be visible to other processes. Are you perhaps misunderstanding temp tables? You cannot see them except from the process that created them. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.