missing FROM-clause entry
Just upgraded to 8.1.5 and the following UPDATE causes the "missing
FROM-clause entry" error:
UPDATE model_timemap
SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map)
WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189
From what I've read, this typically results from referring to a table
instead of it's alias, but I don't see how that applies here.
--
Brandon
you didn't reference the table "replica"... this should work:
UPDATE model_timemap
SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
32191 THEN 5739 ELSE -1 END, 1161642129, map)
FROM replica
WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189
----- Original Message -----
From: "Brandon Metcalf" <bmetcalf@nortel.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, October 24, 2006 12:35 AM
Subject: [GENERAL] missing FROM-clause entry
Show quoted text
Just upgraded to 8.1.5 and the following UPDATE causes the "missing
FROM-clause entry" error:UPDATE model_timemap
SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN
replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map)
WHERE replica.replica_id = model_timemap.replica AND replica.proxy =
32189From what I've read, this typically results from referring to a table
instead of it's alias, but I don't see how that applies here.--
Brandon---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
m == me@alternize.com writes:
m> you didn't reference the table "replica"... this should work:
m> UPDATE model_timemap
m> SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
m> 32191 THEN 5739 ELSE -1 END, 1161642129, map)
m> FROM replica
m> WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189
Ah. Thanks.
--
Brandon