The following bug has been logged online:
Bug reference: 4035
Logged by: RGF
Email address: RussFrith@hotmail.com
PostgreSQL version: latest
Operating system: Windows XP
Description: sql table aliases do not work
Details:
the following sql code throws the following error:
ERROR: relation "tonodes" does not exist
SQL state: 42P01
Context: SQL statement "update tonodes set tonodes.cost = case when
tonodes.cost is NULL then fromnodes.cost + paths.cost when fromnodes.cost +
paths.cost < tonodes.cost then fromnodes.cost + paths.cost else tonodes.cost
end, tonodes.pathid = paths.pathid from nodes as fromnodes inner join paths
on paths.fromnodeid = fromnodes.nodeid inner join tonodes on tonodes.nodeid
= paths.tonodeid where fromnodes.nodeid = $1 and (tonodes.cost is NULL or
fromnodes.cost + paths.cost < tonodes.cost) and tonodes.calculated = 0"
PL/pgSQL function "dijkstra_resolve" line 53 at SQL statement
The tables referenced (nodes and paths) exist and have data. The SQL works
in MS SQL Server 2000
Pls help