Re: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM - Mailing list pgsql-bugs

From Takahiro Itagaki
Subject Re: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM
Date
Msg-id 20100401095342.D026.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM  ("Peter Jukel" <pjukel@triplehash.com>)
List pgsql-bugs
"Peter Jukel" <pjukel@triplehash.com> wrote:

> PostgreSQL version: 8.4
>
> 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.

It will be improved in 9.0, the next release.
Ignore leading UTF-8-encoded Unicode byte-order marker in psql
http://developer.postgresql.org/pgdocs/postgres/release-9-0.html#AEN98917

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center

pgsql-bugs by date:

Previous
From: Andy Balholm
Date:
Subject: Re: dividing money by money
Next
From: Robert Haas
Date:
Subject: Re: BUG #5388: bortdagos