Re: [pgadmin-support] win32 psql syntax error running any .sql created by the query editor

2008-04-07 Thread Raymond O'Donnell
On 07/04/2008 21:34, Kev wrote: 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. Thi

[pgadmin-support] win32 psql syntax error running any .sql created by the query editor

2008-04-07 Thread Kev
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