Errata
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 |
---|---|---|---|---|---|
? Databases and Management, 3rd line |
"The owner of the database will be the logged in user and is a copy of template1 database." -> Note from the Author or Editor: |
Jon Forrest | Jul 20, 2014 | ||
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: |
Ashley Lillywhite | Oct 15, 2012 | |
ePub | Page 22 2nd-to-last line |
Section about "server service" reads "you can have more than one a physical server" Note from the Author or Editor: |
Peter Clark | Oct 01, 2012 | |
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 |
Aug 28, 2012 | Sep 07, 2012 | |
Page 128 Second paragraph below "Querying More Complex Data Sources" |
The sentence in question: Note from the Author or Editor: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 125 End of first paragraph |
There's a typo in this sentence: Note from the Author or Editor: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 125 First paragraph |
Here's the sentence in question: Note from the Author or Editor: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 120 First paragraph after "Table Stats" header |
The erroneous sentence reads: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 120 First paragraph below "Table Stats" heading |
The typo is in this sentence: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 108 Caption for Example 8-12 |
The caption reads: |
Anonymous | Aug 08, 2012 | Sep 07, 2012 | |
Page 107 Beginning of last paragraph |
In the beginning of this sentence: |
Anonymous | Aug 08, 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 |
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 |
Aug 07, 2012 | Sep 07, 2012 |
Printed, PDF | Page 69 Example 5-12 |
Caption on 5-12 typo "suing" should be using |
Leo Hsu |
Aug 07, 2012 | Sep 07, 2012 |
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 |
Aug 07, 2012 | Sep 07, 2012 | |
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 |
Aug 07, 2012 | Sep 07, 2012 | |
Page 10 bullet 1 of example 2-2 |
user context settings require only a reload to take effect globally |
Leo Hsu |
Aug 07, 2012 | Sep 07, 2012 | |
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 |
Aug 07, 2012 | Sep 07, 2012 | |
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 |
Aug 07, 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 |
Aug 07, 2012 | Sep 07, 2012 |
Printed, PDF, , 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." |
Leo Hsu |
Aug 07, 2012 | Sep 07, 2012 |
Page 80 B-tree description paragraph |
The error is in this sentence: Note from the Author or Editor: |
Anonymous | Aug 07, 2012 | Sep 07, 2012 | |
Page 1 Notable PostgreSQL Forks |
Under Notable PostgreSQL Forks theres a sentence which reads Note from the Author or Editor: |
Ian Johnson | Aug 05, 2012 | Sep 07, 2012 |