Re: Performance problems testing with Spamassassin 3.1.0

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>
Cc: PFC <lists(at)boutiquenumerique(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Date: 2005-08-01 21:49:31
Message-ID: 20050801214931.GF60019@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)decibel(dot)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?"

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Parker 2005-08-01 22:09:07 Re: Performance problems testing with Spamassassin 3.1.0
Previous Message Matthew Schumacher 2005-08-01 21:28:24 Re: Performance problems testing with Spamassassin 3.1.0