X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A49752AB0 for ; Sun, 10 Jul 2005 13:10:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43760-09 for ; Sun, 10 Jul 2005 16:10:27 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 16D4C529CC for ; Sun, 10 Jul 2005 13:10:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6AGAPCi011298; Sun, 10 Jul 2005 12:10:25 -0400 (EDT) To: Harald Fuchs Cc: pgsql-sql@postgresql.org Subject: Re: Make COUNT(*) Faster? In-reply-to: References: <9EF2931D-1097-470D-8ECB-59D00166C96F@apple.com> <60vf3mklue.fsf@dba2.int.libertyrms.com> <42CE89CA.2070607@noao.edu> <758d5e7f05070808305c049aae@mail.gmail.com> Comments: In-reply-to Harald Fuchs message dated "10 Jul 2005 14:19:56 +0200" Date: Sun, 10 Jul 2005 12:10:25 -0400 Message-ID: <11297.1121011825@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200507/96 X-Sequence-Number: 22074 Harald Fuchs writes: > FOR row IN EXECUTE 'EXPLAIN SELECT * FROM ' || tbl LOOP > fails with the following message: > ERROR: cannot open non-SELECT query as cursor [ checks CVS history... ] Use 8.0.2 or later. regards, tom lane