BUG #4035: sql table aliases do not work
От | RGF |
---|---|
Тема | BUG #4035: sql table aliases do not work |
Дата | |
Msg-id | 200803142053.m2EKr80T037097@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4035: sql table aliases do not work
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: