Re: ERROR: parser: unterminated quoted string - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: ERROR: parser: unterminated quoted string
Date
Msg-id 20040909134905.73936.qmail@web20824.mail.yahoo.com
Whole thread Raw
In response to ERROR: parser: unterminated quoted string  ("Daniel Secomb" <dan@ds-d.com>)
List pgsql-general
--- 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

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Text Search vs MYSQL vs Lucene
Next
From: Mark Gibson
Date:
Subject: Re: Heritage