Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 1DAAA475A89 for ; Tue, 28 May 2002 13:34:03 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5E2D147597F for ; Tue, 28 May 2002 13:34: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 g4SHXsW11523; Tue, 28 May 2002 13:33:54 -0400 (EDT) To: "Michael Beckstette" Cc: pgsql-sql@postgresql.org Subject: Re: Creation of a table with dynamic name from inside a pgpsql function In-reply-to: <1020528175341.ZM17959@sirari.TechFak.Uni-Bielefeld.DE> References: <1020528175341.ZM17959@sirari.TechFak.Uni-Bielefeld.DE> Comments: In-reply-to "Michael Beckstette" message dated "Tue, 28 May 2002 17:53:41 +0200" Date: Tue, 28 May 2002 13:33:54 -0400 Message-ID: <11520.1022607234@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/297 X-Sequence-Number: 7932 "Michael Beckstette" writes: > query_string:= ''CREATE TABLE temp1 AS SELECT * FROM ''|| > quote_ident(table_name) || '' WHERE (hsp_rank=1 AND hsp_evalue<=0.001)''; > RAISE NOTICE ''Query: %'',query_string; > EXECUTE query_string; > prod2_db=# select test('blasthits_obj_174_q122_db123'); > NOTICE: Query: CREATE TABLE temp1 AS SELECT * FROM > blasthits_obj_174_q122_db123 WHERE (hsp_rank=1 AND hsp_evalue<=0.001) > ERROR: EXECUTE of SELECT ... INTO is not implemented yet Update to 7.2.1. The above should be allowed, but was mistakenly rejected by 7.2. regards, tom lane