Skip site navigation (1) Skip section navigation (2)

Re: I NEED HELP!!! - (ERROR: parser: unterminated quoted

From: Ron St-Pierre <rstpierre(at)syscor(dot)com>
To: Daniel Secomb <dan(at)ds-d(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: I NEED HELP!!! - (ERROR: parser: unterminated quoted
Date: 2004-09-08 15:11:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 <file://%22/html/tea_black_tea.html//%22>*\015\012Fresh 
> range of leaf tea for drinking black or with milk,\015\012including 
> Ceylons, Assams and favourites like Irish 
> Breakfast.\015\012\015\012*Green Tea 
> <file://%22/html/tea_green_tea.html//%22>*\015\012First quality 
> Japanese & Chinese popular green teas, including Bancha, Genmaicha & 
> flavoured green teas.\015\012\015\012*Flavoured Tea 
> <file://%22/html/tea_flavoured_black_tea.html//%22>*\015\012Exotic and 
> delicious, favourites are Vanilla, Arctic Fire & Lady 
> Grey.\015\012\015\012*Herbal Infusions 
> <file://%22/html/tea_herbal_infusions.html//%22>*\015\012Pure flowers 
> and whole leaves of calming herbs, & a\015\012delightful range of 
> specially blended herbal infusions Fruit Melanges;" at character 566
If this is part of a SQL statement, the final quote should be before the 
semicolon. If not check on the previous string to see that it is 
properly quoted/terminated.


In response to

pgsql-novice by date

Next:From: Eduardo Vázquez RodríguezDate: 2004-09-08 21:29:26
Subject: Cast
Previous:From: paulDate: 2004-09-08 14:16:46
Subject: Re: Why am I getting the error: "Cannot insert a duplicate key into unique index"?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group