On Wed, Feb 17, 2010 at 10:38 PM, Josh Berkus <josh@agliodbs.com> wrote:
> All,
>
> Version: 1.10.1
> Platform: OSX 10.5
> Installed From: .dmg
> Severity: Major
> Reproduceable: Always
> Description:
> Every time I create a new SQL file using the SQL editor in pgAdmin, it
> inserts a non-ASCII garbage character at the very beginning of the file.
> This then prevents the file from running, say through psql.
>
> Sometimes it also inserts the character when I edit an existing file,
> but not always. I haven't discerned a pattern here.
>
> The character cannot be viewed in emacs, but can be deleted. This issue
> is completely prohibitive of using the SQL editor in any kind of shared
> system.
It's not garbage, it's a Unicode BOM.
If your other software cannot read Unicode files properly, you can
turn off Unicode file writing under File -> Options.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com