Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Pgadmin Support > win32 psql synt...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 1992 of 2066
Post > Topic >>

win32 psql syntax error running any .sql created by the query editor

by Kev <kevinjamesfield@[EMAIL PROTECTED] > Apr 7, 2008 at 01:34 PM

Hi,

This is reproducible every time on my Windows 2003 Server box running
pgAdmin3 1.8.2 and pgsql 8.3.

1. Open the query editor.
2. Type any valid query.
3. Save.
4. In a DOS box, run psql -f on the file you just saved.

I get the following error:

psql:path/to/test.sql:71: ERROR:  syntax error at or near
"=D0=BF=C2=BB=D1=
=97"
LINE 1: =D0=BF=C2=BB=D1=97select * from cust

If I open the file in TextPad, it says it's of UNIX type.  If I then
save it again using TextPad and run it, it runs fine without errors.

This also happens even if I go Edit->Line Ends-> and choose either DOS
or UNIX in the query editor and then save again.

I could be wrong, but this sounds like a bug.  Thoughts or
suggestions?

Thanks,
Kev
 




 2 Posts in Topic:
win32 psql syntax error running any .sql created by the query ed
Kev <kevinjamesfield@[  2008-04-07 13:34:42 
Re: win32 psql syntax error running any .sql created
rod@[EMAIL PROTECTED] (&  2008-04-07 22:08:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 18:38:21 CDT 2008.