error when using SELECT

From: Andrew Stewart <astew(at)wam(dot)umd(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: error when using SELECT
Date: 2005-07-26 17:39:12
Message-ID: 42E67540.2090309@wam.umd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm currently trying to install a set of Perl modules that interact with
a particular SQL schema (bioperl-db with BioSQL, if anyone is familiar
with them), and am running into a problem that appears to be emergent
with 8.0.3.

I myself am still very new to PostgreSQL, so I'm having trouble telling
if there is anything wrong with the postgres transaction that is being
attempted by the bioperl-db maketest. The verbose error output is as
follows...

preparing SELECT statement: SELECT SUBSTRING(seq FROM ? FOR ?) FROM
biosequence WHERE bioentry_id = ?
ok 30
ok 31
DBD::Pg::st execute failed: ERROR: invalid escape string
HINT: Escape string must be empty or one character.
CONTEXT: SQL function "substring" statement 1
DBD::Pg::st fetchall_arrayref failed: no statement executing
not ok 32

...At first one of the bioperl-db developers thought that the error
might be from the absence of a space between the '?' and 'FOR', but this
was corrected and yet the error persists. Can anyone tell me if any
part of that SELECT statement looks erroneous?

Thanks,
Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-07-26 17:41:13 Re: transaction timeout
Previous Message Ben Trewern 2005-07-26 17:33:12 Re: PostgreSQL, Lazarus and zeos ?