Received: from mx2.imaginet.fr (artemis.imaginet.fr [195.68.75.24]) by hub.org (8.10.1/8.10.1) with ESMTP id e7O9Mf581986 for ; Thu, 24 Aug 2000 05:22:42 -0400 (EDT) Received: from lexbase.net ([195.68.125.34]) by mx2.imaginet.fr (8.9.3/8.8.8) with ESMTP id LAA28761; Thu, 24 Aug 2000 11:20:30 +0200 (MET DST) Message-ID: <39A4EC81.BF9ECFC5@lexbase.net> Date: Thu, 24 Aug 2000 11:36:01 +0200 From: hlefebvre Organization: LEXBASE X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Andreas Tille CC: PostgreSQL SQL Subject: Re: Create table in functions References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/262 Andreas Tille wrote: > What does this mean? The ERROR is caused by the Create Table statement > (when I removed it from my complex function it worked well). > So why doesn't this work and what copy function fails here?? Maybe you can create your table using a select into statement : something like : SELECT int4(1) as Num INTO Temp_NumTable WHERE 1=2; Should create your table without CREATE statement.