Hello everyone! Welcome to the forum for the second edition of Seven Databases in Seven Weeks. I’m one of the co-authors. Please feel free to discuss any aspect of the book that you find intriguing in this space. Hope you enjoy!
I already posess the first edition of this book. Can you explain which are the differences to the first edition?
Running through the v2 beta book - it looks like postgres 10 supports updatable views out of the box for simple views. Running the update query in the holidays view created in day 2 of the postgres chapter just works and doesn’t return the error in the example.
Also, in the crosstab example it might be necessary to include the tablefunc module before the crosstab function is available:
CREATE EXTENSION tablefunc; SELECT * FROM crosstab(...