Re: bytea & perl - Mailing list pgsql-general

From Tom Allison
Subject Re: bytea & perl
Date
Msg-id 3EBBE17A-27A9-44E4-84A2-2745F39F5313@tacocat.net
Whole thread Raw
In response to Re: bytea & perl  (SCassidy@overlandstorage.com)
Responses Re: bytea & perl
List pgsql-general
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@overlandstorage.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.


pgsql-general by date:

Previous
From: Thomas Munz
Date:
Subject: Wired behavor with LIMIT
Next
From: Richard Huxton
Date:
Subject: Re: Wired behavor with LIMIT