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 6337452C2F for ; Mon, 1 Aug 2005 19:09:26 -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 85765-03 for ; Mon, 1 Aug 2005 22:09:21 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id 7C5E952BFA for ; Mon, 1 Aug 2005 19:09:20 -0300 (ADT) Received: from ppp-66-143-176-222.dsl.austtx.swbell.net ([66.143.176.222] helo=mail.herk.net) by outbound.mailhop.org with esmtpsa (TLSv1:DES-CBC3-SHA:168) (Exim 4.51) id 1DziTK-000A8w-7n for pgsql-performance@postgresql.org; Mon, 01 Aug 2005 18:09:22 -0400 Received: from [192.168.1.100] ([192.168.1.1]) (AUTH: LOGIN parker@herk.net) by mail.herk.net with esmtp; Mon, 01 Aug 2005 17:09:20 -0500 id 0011A3A1.42EE9D90.0000707B X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 66.143.176.222 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: parkerm Message-ID: <42EE9D83.8000405@pobox.com> Date: Mon, 01 Aug 2005 17:09:07 -0500 From: Michael Parker User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.6) Gecko/20050317 Thunderbird/1.0.2 Mnenhy/0.7.2.0 X-Accept-Language: en-us, en Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=_mail-28795-1122934160-0001-2" To: pgsql-performance@postgresql.org Subject: Re: Performance problems testing with Spamassassin 3.1.0 References: <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> <42EE8043.1050207@aptalaska.net> <42EE93F8.5010003@aptalaska.net> <20050801214931.GF60019@decibel.org> In-Reply-To: <20050801214931.GF60019@decibel.org> X-Enigmail-Version: 0.91.0.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/11 X-Sequence-Number: 13758 This is a MIME-formatted message. If you see this text it means that your E-mail software does not support MIME-formatted messages. --=_mail-28795-1122934160-0001-2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Jim C. Nasby wrote: >I'm not sure who's responsible for DBI::Pg (Josh?), but would it make >sense to add better support for bytea to DBI::Pg? ISTM there should be a >better way of doing this than adding gobs of \'s. > > It has support for binding a bytea parameter, but in this case we're trying to build up an array and pass that into a stored procedure. The $dbh->quote() method for DBD::Pg lacks the ability to quote bytea types. There is actually a TODO note in the code about adding support for quoting Pg specific types. Presumabliy the difficulties we are having with this would be solved by that, once it has been implemented. In the meantime, I believe it's just a matter of getting the right escapes happen so that the procedure is inserting values that we can later get via a select and using bind_param() with the PG_BYTEA type. Michael --=_mail-28795-1122934160-0001-2 Content-Type: application/pgp-signature; name="signature.asc" Content-Transfer-Encoding: 7bit Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin) iD8DBQFC7p2HG4km+uS4gOIRAn9gAJwL+6XcJLjYloAjO3hOFKvlcTbzVwCeLwsy RJPPQZDWRYPIer0eOcixutE= =xv0t -----END PGP SIGNATURE----- --=_mail-28795-1122934160-0001-2--