PostgreSQL: Up and Running

Errata for PostgreSQL: Up and Running

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed, PDF, Safari Books Online, Other Digital Version
Page xi
first paragraph

"In addition, there is an SQL command you can run — sect_extensions — to see the list of available and installed extensions." The sect_extensions should point to the extensions section in the book

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
Safari Books Online
?
Databases and Management, 3rd line

"The owner of the database will be the logged in user and is a copy of template1 database." -> "The owner of the database will be the logged in user and the database will be a copy of template1 database." It's hard to give page numbers for Safari editions.

Note from the Author or Editor:
already corrected

Jon Forrest  Jul 20, 2014 
PDF
Page 1
Notable PostgreSQL Forks

Under Notable PostgreSQL Forks theres a sentence which reads Various groups have done exactly that over the years., and some have con- tributed their changes. Theres a comma and full stop after years.

Note from the Author or Editor:
Will be fixed in next release

Ian Johnson  Aug 05, 2012  Sep 07, 2012
Printed, PDF
Page 5,87
Chapter 1 and 7

Link to PostgreSQL Manual describing what PostgreSQL rules are. Only existing PostgreSQL users will know what they are.

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
PDF
Page 10
bullet 1 of example 2-2

user context settings require only a reload to take effect globally

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
PDF
Page 17
ALTER DATABASE set search_path example

It is not clear that you need to reconnect to the database after you do this for the changes to take effect

Leo Hsu
O'Reilly Author 
Aug 28, 2012  Sep 07, 2012
PDF
Page 18
Chapter 2

remove TRIGGER permission in ALTER DEFAULT PRIVILEGES example. You generally don't give TRIGGER rights for users that should have read only

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
ePub
Page 22
2nd-to-last line

Section about "server service" reads "you can have more than one a physical server" Should be "one per physical server"

Note from the Author or Editor:
corrected

Peter Clark  Oct 01, 2012 
PDF
Page 26
last paragraph

Clarify when you can use pg_restore to restore a pg_dump backup. You can't use them for plain text pg_dump backups and that wasn't clear.

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
Printed
Page 62
Character Types

The paragraph starts "There are tree basic types of character types in PostgreSQL" Should this not say "Three" rather than "tree"

Note from the Author or Editor:
Fixed should be available in next release

Ashley Lillywhite  Oct 15, 2012 
PDF
Page 65
Example 5-9 explanation

'g' is for global not greedy and matches all occurrences vs. just first occurrence of a pattern

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
PDF
Page 65,66
Chapter 5 temporal data types

There are 9 temporal types as of PostgreSQL 9.2. Added in the 3 temporal range types introduced in 9.2

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
Printed, PDF
Page 69
Example 5-12

Caption on 5-12 typo "suing" should be using

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
PDF
Page 80
B-tree description paragraph

The error is in this sentence: If PostgreSQL automaticaly creates an index for you or you don’t bother picking the type, B-tree will be chosen. "Automatically" is mis-spelled.

Note from the Author or Editor:
Will be fixed in next release

Anonymous  Aug 07, 2012  Sep 07, 2012
Printed, PDF
Page 90-91
first paragraph

note that CTE isn't really a variable name and is often materialized in PostgreSQL

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
Printed, PDF
Page 101
second paragraph

remove incorrect statement about not being able to have multiple SQL statements in an SQL function

Leo Hsu
O'Reilly Author 
Aug 07, 2012  Sep 07, 2012
PDF
Page 107
Beginning of last paragraph

In the beginning of this sentence: For our geomeric mean aggregate, we’ll use two functions... "Geometric" is missing a "t".

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 108
Caption for Example 8-12

The caption reads: Example 8-12. Geometric mean aggregate: Putting all the pirces together "pirces" must be a typo - it should be "pieces".

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 120
First paragraph below "Table Stats" heading

The typo is in this sentence: Its decisions follow prescribed logic that’s far beyond the scope this book Instead of "the scope of this book", the end of that sentence reads "the scope this book".

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 120
First paragraph after "Table Stats" header

The erroneous sentence reads: The rules that the planner follows depends heavily on the current state of the data. The beginning should be "The rules that the planner follows depend heavily on". i.e. remove the "s" from "depends".

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 125
First paragraph

Here's the sentence in question: Although PostgreSQL is improving replication with each new release, Slony, Bucardo, and other third-party still offer more flexibility. Other third-party what? It seems like there is a noun missing.

Note from the Author or Editor:
Fixed. other third-party replication offerings

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 125
End of first paragraph

There's a typo in this sentence: To this end, the rasison d’etre of Postgres-XC is not replication, but distributed query processing. "rasison d'etre" should be "raison d'etre"

Note from the Author or Editor:
Fixed. Will be in next update.

Anonymous  Aug 08, 2012  Sep 07, 2012
PDF
Page 128
Second paragraph below "Querying More Complex Data Sources"

The sentence in question: In this next example, we’ll demonstrate how to use the www_fdw foreign data wrapper to query the web services. I think "to query the web services" should have "the" removed so it reads "to query web services".

Note from the Author or Editor:
Fixed in repo. Will be in next update.

Anonymous  Aug 08, 2012  Sep 07, 2012