Re: bytea & perl

From: Tom Allison <tom(at)tacocat(dot)net>
To: SCassidy(at)overlandstorage(dot)com
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: bytea & perl
Date: 2007-05-25 11:15:21
Message-ID: 3EBBE17A-27A9-44E4-84A2-2745F39F5313@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-05-25 11:56:39 Re: Wired behavor with LIMIT
Previous Message Thomas Munz 2007-05-25 10:41:02 Wired behavor with LIMIT