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 <alvhe...@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
