From: Jim C. Nasby <decibel@decibel.org>
To: Matthew Schumacher <matt.s@aptalaska.net>
Cc: PFC <lists@boutiquenumerique.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Date: Mon, 1 Aug 2005 16:49:31 -0500
Message-ID: <20050801214931.GF60019@decibel.org> (raw)
In-Reply-To: <42EE93F8.5010003@aptalaska.net>
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>
<op.suulgxokth1vuj@localhost>
<42EE93F8.5010003@aptalaska.net>
On Mon, Aug 01, 2005 at 01:28:24PM -0800, Matthew Schumacher wrote:
> PFC wrote:
> >
> >
> >> select put_tokens2(1, '{"\\246\\323\\061\\332\\277"}', 1, 1, 10000);
> >
> >
> > Try adding more backslashes until it works (seems that you need \\\\
> > or something).
> > Don't DBI convert the language types to postgres quoted forms on its
> > own ?
> >
>
> Your right.... I am finding that the proc is not the problem as I
> suspected, it works correctly when I am not calling it from perl,
> something isn't escaped correctly....
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.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: decibel@decibel.org, matt.s@aptalaska.net, lists@boutiquenumerique.com, tgl@sss.pgh.pa.us
Subject: Re: Performance problems testing with Spamassassin 3.1.0
In-Reply-To: <20050801214931.GF60019@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox