Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA19418 for ; Fri, 12 Jun 1998 12:30:33 -0400 (EDT) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id MAA13997; Fri, 12 Jun 1998 12:07:14 -0400 (EDT) From: Bruce Momjian Message-Id: <199806121607.MAA13997@candle.pha.pa.us> Subject: Re: [SQL] DefineQueryRewrite: rule plan string too big To: trowbrid@writeme.com Date: Fri, 12 Jun 1998 12:07:14 -0400 (EDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <199806121601.LAA08339@earth.execpc.com> from "trowbrid@writeme.com" at Jun 12, 98 11:01:56 am X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > First, thanks for the help on sorting by birth month. > BTW: The reason I needed to do that was because otherwise it would have > been sorted by birth year, and a birthday list isn't very convenient > when sorted by year. :-) > > Now I'm trying to create a view with about a dozen (or more) items in the > where clause: > > create view x as select * from table where ID in ('id1','id2','id3','id3', > 'id4','id5','id6','id7','id8','id9','ida','idb','idc','idd'); > > and the error is: > DefineQueryRewrite: rule plan string is too big. > > I looked in the src, and in src/backend/rewrite/RewriteDefine.c, > it mentions something about RULE_PLAN_SIZE being too small, and will > eventually have to be large objects. > > Is this something that's in the works, and is there a workaround? > > TIA > > -- > Tim J Trowbridge trowbrid@writeme.com > Interested in my genealogy? http://www.execpc.com/~trowbrid > > -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)