Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group