X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 315BC52A92 for ; Mon, 1 Aug 2005 01:42:36 -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 96541-07 for ; Mon, 1 Aug 2005 04:42:34 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A6EE052896 for ; Mon, 1 Aug 2005 01:42:33 -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 j714gUpc024579; Mon, 1 Aug 2005 00:42:30 -0400 (EDT) To: Michael Parker Cc: pgsql-performance@postgresql.org Subject: Re: Performance problems testing with Spamassassin 3.1.0 In-reply-to: <20050801040443.GA6527@mail.herk.net> References: <42E80C28.2040608@aptalaska.net> <1122532023.25574.1.camel@localhost.localdomain> <42E9749F.6000709@aptalaska.net> <1122616211.5691.340.camel@lamb.mcmillan.net.nz> <42EA6966.8090402@aptalaska.net> <1122668371.5691.352.camel@lamb.mcmillan.net.nz> <19405.1122670917@sss.pgh.pa.us> <42EAA410.9010700@aptalaska.net> <27897.1122748133@sss.pgh.pa.us> <20050801040443.GA6527@mail.herk.net> Comments: In-reply-to Michael Parker message dated "Sun, 31 Jul 2005 23:04:49 -0500" Date: Mon, 01 Aug 2005 00:42:30 -0400 Message-ID: <24578.1122871350@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/2 X-Sequence-Number: 13749 Michael Parker writes: > The next hurdle, and I've just posted to the DBD::Pg list, is > escaping/quoting the token strings. If you're trying to write a bytea[] literal, I think the most reliable way to write the individual bytes is \\\\nnn where nnn is *octal*. The idea here is: * string literal parser takes off one level of backslashing, leaving \\nnn * array input parser takes off another level, leaving \nnn * bytea input parser knows about backslashed octal values Note it has to be 3 octal digits every time, no abbreviations. regards, tom lane