Re: [ADMIN] syntax error for no apparent reason

Le 04/12/2010 02:45, Josh Berkus a écrit :
>
>> I've encountered this before, psql gives me a syntax error for no clear
>> reason. It's allways on the first character of a sql file.
>> I think that there must be some strange character code at the first
>> position, maybe it is because i share a ntfs partition with the windows
>> installation on my laptop and move files around.
>
> Yeah, this is caused by pgadmin adding a unicode marker at the first
> position of the file.  If you uncheck "Read and Write Unicode UTF-8
> Files" in the preferences, this issue should go away.
>

It goes away because the file is no longer in UTF-8, and that may not be
what the OP wants.

I have a patch ready to be commited that will handle this. But you will
need next pgAdmin's release.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com