Message-ID: <4CF99D40.90306@agliodbs.com>
Date: Fri, 03 Dec 2010 17:45:36 -0800
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2
MIME-Version: 1.0
To: Willy-Bas Loos <willybas@gmail.com>
CC: pgsql-admin@postgresql.org, pgadmin-support@postgresql.org
Subject: Re: [ADMIN] syntax error for no apparent reason
References: <AANLkTin-uSv1ithFyM1ppEQMga7rv2uJASCAeroif9aJ@mail.gmail.com>
In-Reply-To: <AANLkTin-uSv1ithFyM1ppEQMga7rv2uJASCAeroif9aJ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit


> 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.


-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com