The following bug has been logged online: Bug reference: 4035 Logged by: RGF Email address: [EMAIL PROTECTED] 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
