Re: bytea & perl

[Tom Allison <tom(at)tacocat(dot)net>]

I think the quote() part for bytes is deprecated already?

    my $string = "(" . join($glue, map{$dbh->quote($_,PG_BYTEA)} @$tokens) . ")";

returns 

Unknown type 17, defaulting to VARCHAR

as a warning...

On May 24, 2007, at 1:11 PM, SCassidy(at)overlandstorage(dot)com wrote:

Hi,

First, I would advise never using " insert into xx values (y,x)" without explicitly naming the columns;  same for select statements - never use select * (a table change can mess things up).

By the way, I just noticed in the release notes for the very latest couple of versions of DBD:Pg that some placeholder changes were made.  You might want to check the release notes and your version of DBD:Pg about your placeholder issues.