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

Re: BUG #5795: 9.0.2 PDF needs editing

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Leslie Satenstein <lsatenstein(at)yahoo(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5795: 9.0.2 PDF needs editing
Date: 2010-12-20 13:44:24
Message-ID: 1292852536-sup-2576@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-12-20 17:08:47
Subject: Re: BUG #5795: 9.0.2 PDF needs editing
Previous:From: Alvaro HerreraDate: 2010-12-20 13:40:23
Subject: Re: BUG #5795: 9.0.2 PDF needs editing

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