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 69FF5D1CCAD for ; Tue, 30 Mar 2004 16:27:31 +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 56127-01 for ; Tue, 30 Mar 2004 12:27:25 -0400 (AST) Received: from lakemtai06.cox.net (lakemtai06.cox.net [68.1.17.126]) by svr1.postgresql.org (Postfix) with ESMTP id 6CECFD1E929 for ; Tue, 30 Mar 2004 12:27:18 -0400 (AST) Received: from [192.168.0.13] ([68.105.165.18]) by lakemtao02.cox.net (InterMail vM.5.01.06.08 201-253-122-130-108-20031117) with ESMTP id <20040330142030.SFQB13694.lakemtao02.cox.net@[192.168.0.13]>; Tue, 30 Mar 2004 09:20:30 -0500 From: Robert Treat To: Josh Berkus , Andrew Rawnsley , Qing Zhao Subject: Re: column size too large, is this a bug? Date: Tue, 30 Mar 2004 09:20:27 -0500 User-Agent: KMail/1.5 Cc: Tom Lane , Stephan Szabo , pgsql-performance@postgresql.org References: <082D0538-7E86-11D8-8B9C-000A95AB8896@quotefx.net> <8B3A05B5-7F51-11D8-93F3-000393A47FCC@ravensfield.com> <200403281125.41590.josh@agliodbs.com> In-Reply-To: <200403281125.41590.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403300920.27739.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/422 X-Sequence-Number: 6278 On Sunday 28 March 2004 14:25, Josh Berkus wrote: > Andrew, > > > I used to use the connect-by patch, but have since rewritten everything > > to use a nested set model. > > Cool! You're probably the only person I know other than me using nested > sets in a production environment. You cut me deep there Josh, real deep. :-) If you search the pgsql-sql archives you'll find some helpful threads on using nested sets in PostgreSQL, one in particular I was involved with was a generic "move_tree" function that enabled moving a node from one branch to another. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL