Re: bytea & perl

You don't use quote when using placeholders, but you will have to escape
the special characters, as mentioned previously.

The note in DBD:Pg perldoc that says this:

NOTE: The undocumented (and invalid) support for the
"SQL_BINARY"
data type is officially deprecated. Use "PG_BYTEA" with
"bind_param()" instead:

Is talking abojut SQL_BINARY, not PG_BYTEA being deprecated as a type
name.

You use quote when building statements inline, like:

my $modelq=$dbh->quote($model);

$stmt=qq(select id, model from tbl1 where model = $modelq)

Susan Cassidy

Tom Allison <tom(at)tacocat(dot)net>
05/25/2007 04:15 AM

To
SCassidy(at)overlandstorage(dot)com
cc
General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject
Re: [GENERAL] bytea & perl

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.

----------------------------------------------------------------------------------------------
Simply protected storage solutions ensure that your information is
automatically safe, readily available and always there, visit us at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------