BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM

From: "Peter Jukel" <pjukel(at)triplehash(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM
Date: 2010-03-31 04:41:14
Message-ID: 201003310441.o2V4fEMm048826@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5398
Logged by: Peter Jukel
Email address: pjukel(at)triplehash(dot)com
PostgreSQL version: 8.4
Operating system: Mac OSX 10.5.8
Description: psql gives syntax error on .sql files with UTF-8 BOM
Details:

The psql command gives syntax errors when fed .sql files that are saved with
encoding "UTF-8" and contain a BOM (byte order marker). When the same file
is saved using the encoding "UTF-8, no BOM", the syntax error is removed.

The irony is that the query tool supplied with PostGres (PGAdmin) saves with
the BOM. So it would appear to me that any script written in this tool would
display a syntax error.

Regards

Peter

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Teodor Buchner 2010-03-31 13:21:12 BUG #5400: Columns count mismatch in RULE with subquery
Previous Message Craig Ringer 2010-03-31 02:28:42 Re: BUG #5395: UPDATE on shutdown overwrites table