Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id A5A732E301C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 29 Dec 2007 15:16:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 79504-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat, 29 Dec 2007 15:16:32 -0400 (AST)
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.242])
	by postgresql.org (Postfix) with ESMTP id 759522E3012
	for <pgsql-sql@postgresql.org>; Sat, 29 Dec 2007 15:16:34 -0400 (AST)
Received: by an-out-0708.google.com with SMTP id c36so741459ana.33
	for <pgsql-sql@postgresql.org>; Sat, 29 Dec 2007 11:16:33 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=AUXFdzYn0YuZ6yCUEZYMcb6ZrVN3SvWaJtzdkzEfyjY=;
	b=k7O0g9u2syRUIgOZX1BlsQa5CjeQuX3AJ9hgqNG/ehyDENbICjl4Ig+LmxsUefJJno6fzb1D+OLYw88Fq3i1gdG7xxP8I8BJYe2jtfGq+5NaBoct1gOqQen4vlW33Dd58MsNWWD8MOZmzfUYec/lD1zAikBth43tb8APXfTWkHs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=H/mYoU2Om56sPRk9pKNW+9/PmvtMlt7srfvF3MnuizbSPP03G8T8h9TyoTVjb5wqdleiautqSTROlZ+iI09t/Q3FTV1qB7Jua21koOnElp4BJ9JAldvXyKK0IwU1dmr94u2XOi9x2QhAC9mPUa8IgVld0Ke5/1bVGXaJRYD8pRE=
Received: by 10.100.207.5 with SMTP id e5mr13268130ang.103.1198955793687;
	Sat, 29 Dec 2007 11:16:33 -0800 (PST)
Received: by 10.100.92.16 with HTTP; Sat, 29 Dec 2007 11:16:33 -0800 (PST)
Message-ID: <95f6bf9b0712291116lc3c1df0o978922176e98f8d7@mail.gmail.com>
Date: Sat, 29 Dec 2007 20:16:33 +0100
From: "Marcin Krawczyk" <jankes.mk@gmail.com>
To: pgsql-sql@postgresql.org
Subject: temp table existence
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_8914_27427921.1198955793656"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/152
X-Sequence-Number: 29844

------=_Part_8914_27427921.1198955793656
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all. Is there a way to determine the existence of a TEMP
TABLE? I need to check i it exists before I create it. Doing simple
check on pg_class or pg_tables is
not enough because there may be other such tables created in other sessions.
Or maybe anyone knows the identification (apart from 'others') of error to
trap it with EXCEPTION clause?

------=_Part_8914_27427921.1198955793656
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all. Is there a way to determine the existence of a TEMP TABLE?&nbsp;I&nbsp;need&nbsp;to&nbsp;check&nbsp;i&nbsp;it&nbsp;exists&nbsp;before&nbsp;I&nbsp;create&nbsp;it.&nbsp;Doing&nbsp;simple&nbsp;check&nbsp;on&nbsp;pg_class&nbsp;or&nbsp;pg_tables&nbsp;is<br>not&nbsp;enough because there may be other such tables created in other sessions. Or maybe anyone knows the identification (apart from &#39;others&#39;) of error to trap it with EXCEPTION clause?
<br> 

------=_Part_8914_27427921.1198955793656--