missing FROM-clause entry - Mailing list pgsql-general

From Brandon Metcalf
Subject missing FROM-clause entry
Date
Msg-id Pine.LNX.4.58L.0610231732310.1695@cash.us.nortel.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: failing 8.1.4 autovacuum
Next
From: "Thomas H."
Date:
Subject: Re: missing FROM-clause entry