Re: BUG #5795: 9.0.2 PDF needs editing

Excerpts from Leslie Satenstein's message of dom dic 19 23:39:38 -0300 2010:

> The insert examples in section 2.4 do not function if a cut and paste from
> pdf to psql is done
>
> This is the problem
> INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25,
> ’1994-11-27’);
> The fields city and date should have ' as delimiter, not
> ’
> Corrected is the following that works. Error messages are not clear. It
> would be great if psql indicated invalid character as error type.

The problem is that ’ seems to be a valid character for identifiers:

alvherre=# create table ’oh’ (’ah’ int);
CREATE TABLE
alvherre=# \d ’oh’
Tabla «alvherre.’oh’»
Columna │ Tipo │ Modificadores
─────────┼─────────┼───────────────
’ah’ │ integer │

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support