X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CDE1FD1ECC2 for ; Fri, 26 Mar 2004 00:39:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55208-02 for ; Thu, 25 Mar 2004 20:39:26 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B2345D1ECBC for ; Thu, 25 Mar 2004 20:39:18 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2Q0dPZJ016477; Thu, 25 Mar 2004 19:39:26 -0500 (EST) To: Stephan Szabo Cc: Qing Zhao , pgsql-performance@postgresql.org Subject: Re: column size too large, is this a bug? In-reply-to: <20040325145525.V50544@megazone.bigpanda.com> References: <082D0538-7E86-11D8-8B9C-000A95AB8896@quotefx.net> <20040325145525.V50544@megazone.bigpanda.com> Comments: In-reply-to Stephan Szabo message dated "Thu, 25 Mar 2004 14:57:28 -0800" Date: Thu, 25 Mar 2004 19:39:25 -0500 Message-ID: <16476.1080261565@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/368 X-Sequence-Number: 6224 Stephan Szabo writes: > On Thu, 25 Mar 2004, Qing Zhao wrote: >> start with customer_part_number = 'Top Assembly 1' >> connect by parent_part_number = prior customer_part_number; > What version are you running, and did you apply any patches (for example > one to support the start with/connect by syntax used above?) Oh, good eye ... it's that infamous CONNECT BY patch again, without doubt. I think we should add "Have you applied any patches to your copy of Postgres?" to the standard bug report form ... regards, tom lane