Giustiniano (2) [Avatar] Offline
#1
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
#2
Re: SQL syntax error on page 78
Enrico,

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.