Message-ID: <4CFA3817.2020400@lelarge.info>
Date: Sat, 04 Dec 2010 13:46:15 +0100
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr;
	rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
CC: Willy-Bas Loos <willybas@gmail.com>, pgsql-admin@postgresql.org,
	pgadmin-support@postgresql.org
Subject: Re: [ADMIN] syntax error for no apparent reason
References: <AANLkTin-uSv1ithFyM1ppEQMga7rv2uJASCAeroif9aJ@mail.gmail.com>
	<4CF99D40.90306@agliodbs.com>
In-Reply-To: <4CF99D40.90306@agliodbs.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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