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?