Giustiniano (2) [Avatar] Offline
On page 78, when creating a topology the instruction given is
SELECT CreateTopology('ch02_topology',4326);

but it does not work, to create a topology you have to type

SELECT topology.CreateTopology('ch02_topology',4326);
regina.leo (254) [Avatar] Offline
Re: SQL syntax error on page 78

You shouldn't have to include topology. in the call. When you install topology it should automatically add the topology schema to your database search path.

Can you confirm it does and that you don't have a user specified search_path.
To confirm connect to your database and run the command

Do a:

show search_path;

You should see topology listed there.