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
PDF
Page xi
1st and 2nd paragraphs

Three comma spacing errors observed on Preface | xi Space before comma observed, excerpted: 1. With CREATE EXTENSION , you 2. postgis spatial extension , and And in the original text, marked by **** after instance 'If building your own types and functions is not your thing, you have a wide variety of built-in data types, such as JSON introduced in 9.2, and extensions that provide more types to choose from. Many of these extensions are packaged with PostgreSQL distros. PostgreSQL 9.1 introduced a new SQL construct, CREATE EXTENSION, which allows you to install the many available extensions with a single SQL statement for each in a specific database. With CREATE EXTENSION ,**** you can install in your database any of the aforementioned PL languages and popular types with their companion functions and operators, like hstore key-value store, ltree hierarchical store, postgis spatial extension ,**** and countless others. For example, to install the popular PostgreSQL key-value store type and its companion functions and operators, you would type:' No space around comma observed, excerpted: 3. can run,see “Extensions And in the original text, marked by **** after instance 'In addition, there is an SQL command you can run,see**** “Extensions and Contribs” on page 26 for list of available and installed extensions.'

Note from the Author or Editor:
Should be mostly fixed now in our manuscript. I think some were caused by things we thought were spaces but rally unprintable characters when it came to pdf gen so just retyped the space in.

Erik Vitands  Jun 30, 2014 
PDF
Page xii
Heading: For More Information on PostgreSQL, 1st paragraph

One spacing error observed on Preface | xii No space after quotation mark observed, excerpted: cool “Eureka!"stuff And in the original text, marked by **** after instance: 'This book is geared at demonstrating the unique features of PostgreSQL that make it stand apart from other databases, as well as how to use these features to solve real world problems. You’ll learn how to do things you never knew were possible with a database. Aside from the cool “Eureka!"stuff,**** we will also demonstrate bread-and-butter tasks, such as how to manage your database, how to set up security, troubleshoot performance, improve performance, and how to connect to it with various desktop, command-line, and development tools.'

Erik Vitands  Jun 30, 2014 
PDF
Page 9
sequence paragraph

"Both SQL Servaer[sic] and Oracle have sequence objects" From PDF copy obtained 7/21/14

Note from the Author or Editor:
Fixed in draft. Should show in next draft release.

Anonymous  Jul 22, 2014 
PDF
Page 15
United States

The link to the ruby driver is out of date. Rubyforge is no longer in operation. Here's the link I would recommend. https://rubygems.org/gems/pg

Note from the Author or Editor:
We've updated in our 2nd editon draft.

Ryan Malecky  Jul 29, 2014 
ePub
Page 20
schema paragraph

The sentence "If you think of the database as being a county, schemas would bee the individual states" I believe you meant country, not county

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

Patrick Carlson  Aug 06, 2014 
ePub
Page 27
sequence paragraph

Last line has the word Server spelled as Servaer

Note from the Author or Editor:
already corrected

Patrick Carlson  Aug 06, 2014 
ePub
Page 29
Why Upgrade, 1st paragraph, last sentence

Missing word. assuming you can even locate someone willing to the work, should read assuming you can even locate someone willing to do the work.

Note from the Author or Editor:
already corrected

Patrick Carlson  Aug 06, 2014 
ePub
Page 35
PostgreSQL 9.2: New Features 2nd bullet item

Improve of in-memory sort operations by as much as 20%. Could be changed to either 1. Improvement of in-memory sort operations by as much as 20%. or 2 Improved in-memory sort operations by as much as 20%.

Note from the Author or Editor:
Already corrected in latest draft

Patrick Carlson  Aug 06, 2014 
PDF
Page 37
Second section heading

"Don’t Givie[sic] Full Administrative Rights to the Postgres System (Daemon) Account" spurious letter 'i' before the e of 'Give'.

Note from the Author or Editor:
Hmm not seeing it in 2nd edition. We might have fixed it since last run since I do recall seeing that typo and fixing it.

Graham Hay  May 30, 2014 
ePub
Page 58
Materialized Views section

2 sentence. You can new persist data into frequently used views to avoid making repeated retrieval calls for slow queries. new should be now

Note from the Author or Editor:
already corrected

Patrick Carlson  Aug 06, 2014