Anthony DeBarros
Anthony DeBarros
You're welcome. Yes, you can make the change permanent by editing the value in your postgresql.conf file and re-starting PostgreSQL. Take a look at the section "Changing Server Settings" in...
Hey, Josh! 👋 So, you're saying to comment out all the COPY statements in these .sql files so that a reader could create all the tables at once by running...
OK, that sounds like a good idea. I'll switch that up when I revise the chapter based on your additional comments. Thanks!
Hello, @marcosroot -- thanks for letting me know. It seems that error is present in the Kindle version as well. However, the code is correct in the print copies and...
@anthonysim That line of code is correct as-is. Although you could insert `AS` before the table alias, it's not required. In fact, you can even omit `AS` when aliasing column...
Hello @emiliemercier -- You want to use the `LIMIT` keyword. You can find that solution with all the Try It Yourself exercises in the below file, which is in the...
Hi, @robml, EDB has changed how to its Python support is configured for Windows since the first edition arrived in 2018. Here are screen shots from the Python install instructions...
You're very welcome. I'm always happy to hear from readers and glad to help! I unfortunately do not know a workaround on Windows, and I agree that it is frustrating....
Hi, there is no problem with the code or data. You must follow the book's instructions as outlined in the Introduction. Please see my reply on this topic on a...
One other thing -- make sure you created the `us_counties_2010` table using the code in the repository files, not by copying the code from a PDF of the book!