ERROR: parser: unterminated quoted string

[Daniel Secomb]

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\012Fres h range of leaf tea for drinking black or with
milk,\015\012in cluding Ceylons, Assams and favourites like Irish
Breakfast.\015\ 012\015\012Gree n Tea\015\012Firs t quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha & flavoured green
teas.\015\012\0 15\012Flavoured Tea\015\012Exot ic and delicious, favourites
are Vanilla, Arctic Fire & Lady Grey.\015\012\0 15\012Herbal
Infusions\015\0 12Pure flowers and whole leaves of calming herbs, &
a\015\012deligh tful range of specially blended herbal infusions Fruit
Melanges;" at character 566

Any idea as to why this is doing this?

Thank you for your help.

Dan

[Jeremy Semeiks]

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\012Fres h range of leaf tea for drinking black or with
milk,\015\012in cluding Ceylons, Assams and favourites like Irish
Breakfast.\015\ 012\015\012Gree n Tea\015\012Firs t quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha & flavoured green
teas.\015\012\0 15\012Flavoured Tea\015\012Exot ic and delicious, favourites
are Vanilla, Arctic Fire & Lady Grey.\015\012\0 15\012Herbal
Infusions\015\0 12Pure flowers and whole leaves of calming herbs, &
a\015\012deligh tful 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Jeff Eckermann]

--- Daniel Secomb <da*@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\012Fres h range of leaf tea for
drinking black or with
milk,\015\012in cluding Ceylons, Assams and
favourites like Irish
Breakfast.\015\ 012\015\012Gree n Tea\015\012Firs t
quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha &
flavoured green
teas.\015\012\0 15\012Flavoured Tea\015\012Exot ic and
delicious, favourites
are Vanilla, Arctic Fire & Lady
Grey.\015\012\0 15\012Herbal
Infusions\015\0 12Pure flowers and whole leaves of
calming herbs, &
a\015\012deligh tful 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org