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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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 "п»ї"
LINE 1: п»їselect * 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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group