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.

ajscilingo (2) [Avatar] Offline
#1
I found this chapter not so straight forward. First there wasn't a hstore.sql file in the sharecontrib folder, but I was able to add it under the "new extension" command in pgAdmin III to my database and that seemed to work.

Secondly I am running into problems trying to add the vw_paris_points view to the geometry_columns table, whenever I run

SELECT populate_geometry_columns('ch03.vw_paris_points');

I see this:


ERROR: invalid input syntax for type oid: "ch03.vw_paris_points"
LINE 1: SELECT populate_geometry_columns('ch03.vw_paris_points');
^

********** Error **********

ERROR: invalid input syntax for type oid: "ch03.vw_paris_points"
SQL state: 22P02
Character: 34
ajscilingo (2) [Avatar] Offline
#2
Re: Chapter 3 issues
This seemed to work however:

SELECT populate_geometry_columns('ch03.vw_paris_points'::regclass);

what does regclass do?