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

Re: BUG #5795: 9.0.2 PDF needs editing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Leslie Satenstein <lsatenstein(at)yahoo(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5795: 9.0.2 PDF needs editing
Date: 2010-12-20 17:08:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> 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:

Yeah, the parser will take most non-ASCII UTF-8 characters as being
identifier characters.  But the real question is why Leslie is getting
 and not plain ' when he copies and pastes.

What I can see from here:
	* the character in the SGML source is definitely plain '
	* what is in the PDF file displays like a fancy curly quote
	* copying and pasting it, however, gives plain ' for me

The PDF file I used was built by me on Fedora 13; it may or may not
exactly match what Devrim distributes.  I used Preview on OS X to
display the PDF.

So what it looks like from here is that platform-specific differences in
the copy/paste process may be at issue.

Whatever the true story, I don't think there's a darn thing we can do
about it.  The characters are correct in the SGML source, and we are not
in a position to fix whatever subtle bugs may or may not be present in
the PDF generation process.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2010-12-20 17:26:45
Subject: Re: BUG #5795: 9.0.2 PDF needs editing
Previous:From: Alvaro HerreraDate: 2010-12-20 13:44:24
Subject: Re: BUG #5795: 9.0.2 PDF needs editing

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