Received: from serwer ([213.25.37.66]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f94G45n21347 for ; Thu, 4 Oct 2001 12:04:05 -0400 (EDT) (envelope-from jasiek@lamer.pl) Received: from pe156.krakow.cvx.ppp.tpnet.pl ([213.76.40.156] helo=lamer.pl) by serwer with esmtp (Exim 3.12 #1 (Debian)) id 15ooSH-0006al-00 for ; Wed, 03 Oct 2001 18:01:05 +0200 Message-ID: <3BBC8594.46955E26@lamer.pl> Date: Thu, 04 Oct 2001 17:51:48 +0200 From: Tomasz Myrta X-Mailer: Mozilla 4.78 [en] (Win98; U) X-Accept-Language: pl,en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: temporary views Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/53 X-Sequence-Number: 5008 Hi I have simple question: How to create view on a temporary table? I need this, because pl/pgsql function returns data via temporary table. View created on a temporary table is useful only to the end of session. Next time i create the same temp table i get "Table xxx with oid xxx doesn't exist" Tomek