On Wed, Feb 17, 2010 at 10:38 PM, Josh Berkus <j...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support