Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D89644761AD for ; Thu, 4 Jul 2002 22:40:09 -0400 (EDT) Mailbox-Line: From tgl@sss.pgh.pa.us Thu Jul 4 22:40:09 2002 Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id B2AA247649E for ; Thu, 4 Jul 2002 22:33:02 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g652Wu207541; Thu, 4 Jul 2002 22:32:56 -0400 (EDT) To: Bruce Momjian Cc: Christopher Kings-Lynne , Mark Frazer , pgsql-sql@postgresql.org Subject: Re: Possible Bug regarding temp tables (sql or psql?) In-reply-to: <200207050209.g6529RT19334@candle.pha.pa.us> References: <200207050209.g6529RT19334@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Thu, 04 Jul 2002 22:09:27 -0400" Date: Thu, 04 Jul 2002 22:32:56 -0400 Message-ID: <7538.1025836376@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-4.6 required=5.0 tests=IN_REP_TO,X_NOT_PRESENT,SUBJ_HAS_Q_MARK version=2.30 X-Spam-Level: X-Archive-Number: 200207/53 X-Sequence-Number: 8432 Bruce Momjian writes: > TODO has: > * Allow psql \d to show temporary table structure > Looks like it works fine now with schemas: More accurately, it's no more broken for temp tables than any other tables at the moment. regression=# create table foo (f1 int); CREATE TABLE regression=# create temp table foo (f1 text, f2 float); CREATE TABLE regression=# \d foo Table "foo" Column | Type | Modifiers --------+------------------+----------- f1 | integer | f1 | text | f2 | double precision | regression=# Even uglier cases occur if some other connection has also created a temp table named foo. You should *not* see that in \d ... but you will. > I will mark the TODO as done. It's not really done, but the remaining fixes will fall out of making psql schema-aware. regards, tom lane