Thread: Error Message: ERROR: syntax error at or near ""
-- System Information --<br /><br />Platform: Windows ME<br />Version: 4.90<br />Build: 3000 <br /><br />-- Application Information--<br /><br />Name: pgAdmin II<br />Version: 1.6.0<br />Descripton: <br /><br />Name: pgSchema<br />Version: 1.6.0<br/>Descripton: PostgreSQL Schema Objects v1.6.0<br /><br />-- Database Information --<br /><br />Version: 7.3.4<br/>Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)<br /><br />--Driver Information --<br /><br />Name: PostgreSQL<br />Version: 7.3.100<br />Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin,compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)<br /><br />-- Error Information --<br /><br />Description:ERROR: syntax error at or near ""<br />Number: -2147467259<br />Routine: pgAdmin II:frmSQLOutput.cmdSave_Click<br/><br />************************************************************<br /><br /><a href="http://www.mail.bg/ads/adclick.php?bannerid=935&zoneid=13&source=&ismap="target="_blank"><br /><br /> -----------------------------АВТОРСКИ картички от Mail.bg Календар на ВСИЧКИ празници http://mail.bg/greetings/ </a><divid="beacon_935" style="position: absolute; left: 0px; top: 0px; visibility: hidden;"><img alt="" height="0" src="http://www.mail.bg/ads/adlog.php?bannerid=935&clientid=330&zoneid=13&source=&block=0&capping=0&cb=0991e1027174c9345304da4f1b82124b" style="width:0px; height: 0px;" width="0" /></div>
Mind the single quote / double quote differencies... PostgreSQL sometimes
requires you to use single quotes.
If I'm not mistaken: single quotes are for litteral reading. eg. case
sensitivity...
hope it helps a bit,
Michiel L.
================================================
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.
================================================
The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.
mario_3@mail.bg
Sent by: pgadmin-support-owner@postgresql.org
29-12-2003 13:03
To: pgadmin-support@postgresql.org cc: Subject: [pgadmin-support] Error Message: ERROR:
syntaxerror at or near ""
-- System Information --
Platform: Windows MEVersion: 4.90
Build: 3000
-- Application Information --
Name: pgAdmin II
Version: 1.6.0
Descripton:
Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0
-- Database Information --
Version: 7.3.4Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin, compiled by
GCC gcc (GCC) 3.2 20020927 (prerelease)
-- Driver Information --
Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin, compiled by GCC gcc (GCC)
3.2 20020927 (prerelease)
-- Error Information --
Description: ERROR: syntax error at or near ""
Number: -2147467259
Routine: pgAdmin II:frmSQLOutput.cmdSave_Click
************************************************************
I've got this kind of error before using the psql command line and it was
related to the client program having a different version than the database
server. Perhaps pgadmin 3 would work? Or perhaps there is an upgrade for
the database driver. My goal would be to get as much of your setup to the
same versions as possible. For what it's worth,
Tyler
mario_3@mail.bg
Sent by:
pgadmin-support-o To
wner@postgresql.o pgadmin-support@postgresql.org
rg cc
Fax to
12/29/2003 04:03
AM Subject
[pgadmin-support] Error Message:
ERROR: syntax error at or near ""
-- System Information --
Platform: Windows ME
Version: 4.90
Build: 3000
-- Application Information --
Name: pgAdmin II
Version: 1.6.0
Descripton:
Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0
-- Database Information --
Version: 7.3.4
Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin, compiled by GCC gcc (GCC)
3.2 20020927 (prerelease)
-- Driver Information --
Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.3.4 on i686-pc-cygwin, compiled by GCC gcc (GCC)
3.2 20020927 (prerelease)
-- Error Information --
Description: ERROR: syntax error at or near ""
Number: -2147467259
Routine: pgAdmin II:frmSQLOutput.cmdSave_Click
************************************************************
----------------------------- АВТОРСКИ картички от Mail.bg Календар на
ВСИЧКИ празници http://mail.bg/greetings/
(Embedded image moved to file: pic05805.gif)
