Re: [GENERAL] bytea & perl

2007-05-25 Thread SCassidy
del = $modelq) Susan Cassidy Tom Allison <[EMAIL PROTECTED]> 05/25/2007 04:15 AM To [EMAIL PROTECTED] cc General PostgreSQL List Subject Re: [GENERAL] bytea & perl I think the quote() part for bytes is deprecated already? my $string = "(" . join($glue, map{$db

Re: [GENERAL] bytea & perl

2007-05-25 Thread Tom Allison
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, [EMAIL PROTECTED] wrote: Hi, First, I would advise never

Re: [GENERAL] bytea & perl

2007-05-24 Thread tom
On 5/24/2007, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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

Re: [GENERAL] bytea & perl

2007-05-24 Thread SCassidy
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 tha