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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin