The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

Giustiniano (2) [Avatar] Offline

first and foremost I'd like to thank the authors for this great book I am enjoying very much and Manning for allowing us the Early Access Program.

This being said, I think there's a mistake on the SQL instruction on page 26, the instruction is:

vacuum analyze ch01.roads;

just after inserting the data in the ch01.highways. This instruction fails to succeed because there's no ch01.roads in the schema. Maybe you meant ch01.highways, which would make sense since it's the table we just inserted data into from the CSV?

regina.leo (265) [Avatar] Offline
Re: Possible error in SQL instruction on page 26

Thanks for the correction. We've updated and should be available in next MEAP release.