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 C86FE550EE for ; Tue, 8 Mar 2005 12:17:06 +0000 (GMT) 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 45825-03 for ; Tue, 8 Mar 2005 12:17:02 +0000 (GMT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id 46491545F2 for ; Tue, 8 Mar 2005 12:17:01 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 4.42) id 1D8de3-000KTt-Fd; Tue, 08 Mar 2005 12:17:04 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id E872016E0C; Tue, 8 Mar 2005 12:17:00 +0000 (GMT) Message-ID: <422D97BF.2080307@archonet.com> Date: Tue, 08 Mar 2005 12:17:03 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Larry Rosenman Cc: pgsql-sql@postgresql.org Subject: Re: Query issue/8.0.1/Serendipity References: <200503080548.17179.ler@lerctr.org> In-Reply-To: <200503080548.17179.ler@lerctr.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/125 X-Sequence-Number: 20604 Larry Rosenman wrote: > I have an 8.0.1 server running the Blogging software serendipity, and the > following query fails with "relation e not defined", but it is on the first > line: > > "SELECT timestamp FROM serendipity_entries e, serendipity_category c, > serendipity_entrycat ec LEFT OUTER JOIN serendipity_entryproperties I think this line here is the problem. You've told it to LEFT OUTER JOIN from "ec", not "e". > ep_cache_extended ON (e.id = ep_cache_extended.entryid AND > ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN > serendipity_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid > AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN > serendipity_entryproperties ep_access ON (e.id = ep_access.entryid AND > ep_access.property = 'ep_access') LEFT JOIN serendipity_entryproperties > ep_sticky ON (e.id = ep_sticky.entryid AND ep_sticky.property = > 'ep_is_sticky') WHERE e.timestamp >= 1109656800 AND e.timestamp <= 1112335200 > AND e.timestamp <= 1110241185 AND e.isdraft = 'false' AND (ep_access.property > IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR > (ep_access.value = 'private' AND e.authorid = 1)) AND e.id = ec.entryid AND > c.categoryid = ec.categoryid AND c.category_left BETWEEN 3 AND 4" -- Richard Huxton Archonet Ltd