ERROR: parser: unterminated quoted string

On Wed, Sep 08, 2004 at 04:05:10PM +1000, Daniel Secomb wrote:

Hi,

I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following
error when I try and run a SQL query on a script:

Error -
/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php --
Line: 33
PostgreSQL said: ERROR: parser: unterminated quoted string at or near
"'Black Tea\015\012Fresh range of leaf tea for drinking black or with
milk,\015\012including Ceylons, Assams and favourites like Irish
Breakfast.\015\012\015\012Green Tea\015\012First quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha & flavoured green
teas.\015\012\015\012Flavoured Tea\015\012Exotic and delicious, favourites
are Vanilla, Arctic Fire & Lady Grey.\015\012\015\012Herbal
Infusions\015\012Pure flowers and whole leaves of calming herbs, &
a\015\012delightful range of specially blended herbal infusions Fruit
Melanges;" at character 566

Any idea as to why this is doing this?

Hi Daniel,

Without seeing the entire query I can't be sure, but I'm guessing there
should be a single quote after "Melanges" and before the semicolon.
(Remember that all strings in Postgres need to be in single quotes, so
unless the semicolon is actually part of the string and not the SQL
statement, that's the cause of the syntax error.)

HTH,
Jeremy

--- Daniel Secomb <dan@ds-d.com> wrote:

Hi,

I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and
I'm getting the following
error when I try and run a SQL query on a script:

Error -

/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php

--
Line: 33
PostgreSQL said: ERROR: parser: unterminated quoted
string at or near
"'Black Tea\015\012Fresh range of leaf tea for
drinking black or with
milk,\015\012including Ceylons, Assams and
favourites like Irish
Breakfast.\015\012\015\012Green Tea\015\012First
quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha &
flavoured green
teas.\015\012\015\012Flavoured Tea\015\012Exotic and
delicious, favourites
are Vanilla, Arctic Fire & Lady
Grey.\015\012\015\012Herbal
Infusions\015\012Pure flowers and whole leaves of
calming herbs, &
a\015\012delightful range of specially blended
herbal infusions Fruit
Melanges;" at character 566

Any idea as to why this is doing this?

Because there is an unterminated quoted string? I see
a single quote just before "Black Tea", but I don't
see another anywhere in that string.

Thank you for your help.

Dan

__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail