Re: BUG #5795: 9.0.2 PDF needs editing - Mailing list pgsql-bugs

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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support