Received: from FW-INTERNAL.ubiquity.com ([202.138.193.106]) by postgresql.org (8.11.3/8.11.4) with SMTP id g14AV8l91124 for ; Mon, 4 Feb 2002 05:31:09 -0500 (EST) (envelope-from murray@efone.com) Received: (qmail 27165 invoked from network); 4 Feb 2002 21:30:18 -0000 Received: from unknown (HELO efone.com) (192.168.2.12) by fw-internal.ubiquity.com with SMTP; 4 Feb 2002 21:30:18 -0000 Message-ID: <3C5E6329.3000805@efone.com> Date: Mon, 04 Feb 2002 21:32:09 +1100 From: Murray Prior Hobbs Organization: eFone International Pty Ltd User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2.1) Gecko/20010901 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: temporary tables, plpgsql and yes i bet this has been asked before Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/37 X-Sequence-Number: 6469 in a plpgsql function create temporary table X .... drop table X then in another function loop call the other function end loop i get the problem that the second time the table is created (ie in the second call) it is not visible now yes i could declare the table in the calling funtion but then the original function is less useful to me any clues? murray