small medium large xlarge

The latest version of the book is P1.0, released 7 months ago. If you've bought a PDF of the book and would like to update it to this version (for free), visit your home page.

By default this page displays the errata for the latest version of the book. If you have a previous version, select it here:

If you've found a new error, please submit it.

  • Typo
  • Tech. error
  • Suggestion
  • Maybe next edition
  • Not a problem
  • Reported in: P1.0 (11-Nov-18)
#83892
PDF page: 0
Section: PostgreSQL 'I'll meet you at the cross tab' (no page numbers in Safaribooksonline docs): Problem: When calling the function 'crosstab', ...more...
  • Reported in: P1.0 (23-Jul-18)
#83396
PDF page: 10
Re: the table to pivot around for crosstab() in Day 2 of postgresql An explicit list of values is no longer required by crosstab() in postgresql. ...more...
  • Reported in: P1.0 (17-Apr-18)
#83014
PDF page: 17
Hi there! The dates in the table containing Fight Club, April Fool's Day, and Christmas appear to have some copy pasta. The "starts" date for Chris...more...
  • Reported in: P1.0 (17-Jun-18)
#83274
PDF page: 42
Paper page: 42
Replace cat `pg_config --sharedir`/tsearch_data/english.stop with cat `locate english.stop` pg_config is installed only if the developer st...more...
  • Reported in: P1.0 (09-Nov-18)
#83879
PDF page: 43
Paper page: 29
The book suggests using the createlang command $ createlang 7dbs --list In pg 10, this gave an error: Error: pg_wrapper: createlang was not f...more...
  • Reported in: P1.0 (01-Jul-18)
#83313
Paper page: 96

On page 95, party was set to "D", but on page 96 it's listed as "I".

  • Reported in: P1.0 (11-Apr-18)
#82983
Paper page: 185

The vintages on the figure are all 2007, but they should be 2015, 2010 & 2002--Jean-François "Jeff" Héon

  • Reported in: P1.0 (12-Apr-18)
#83001
PDF page: 185
On the figure, we should have a double grape_type relationship between the Prancing wolf ice wine and Riesling. One that was specified exactly on ice ...more...
  • Reported in: P1.0 (12-Apr-18)
#83000
PDF page: 186
This query returns nothing (because no friends relationships starts from Alice) MATCH (p:Person {name: "Alice"})-->(other: Person) RETURN other.na...more...
  • Reported in: P1.0 (21-Oct-18)
#83804
PDF page: 187
MATCH (p1:Person {name: "Kofi"}),(p2:Person {name: "Tom"}); CREATE (p1)-[r:friends]->(p2); MATCH ... ; CREATE ...; Between the MATCH and the CR...more...
  • Reported in: P1.0 (21-Oct-18)
#83806
PDF page: 190
$ curl -i -XPOST ..... \ -H "Content-Type: application/json" \ -d '{ "name": "P.G. Wodehouse" "genre": "British Humour" }' Missing a comma in ...more...
  • Reported in: P1.0 (07-Apr-18)
#82965
PDF page: 234

In Day 2 of DynamoDB
Section: Getting our Keys Right

ReadingId attribute is mentioned but not used in SensorData table.--sydcanem

  • Reported in: P1.0 (23-Apr-18)
#83039
PDF page: 264
Or we can retrieve all hash keys. redis 127.0.0.1:6379> HVALS user:luc 1) "name" 2) "password" instead of redis 127.0.0.1:6379> HKEYS user:lu...more...
  • Reported in: P1.0 (04-Nov-18)
#83856
PDF page: 285
$ ruby data_dump_cluster.rb 10000 100000 items in 6.614907 seconds You have to add a 0 to TOTAL_NUMBER_OF_ENTRIES to insert 100000 keys. --Ariel ...more...