Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
missing FROM-clause entry
- From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: missing FROM-clause entry
- Date: Mon, 23 Oct 2006 17:35:53 -0500 (CDT)
- Message-id: <Pine(dot)LNX(dot)4(dot)58L(dot)0610231732310(dot)1695(at)cash(dot)us(dot)nortel(dot)com>
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
- Follow-Ups:
- Re: missing FROM-clause entry
- From: Thomas H.
- Re: missing FROM-clause entry
- Prev by Date: failing 8.1.4 autovacuum
- Next by Date: Re: missing FROM-clause entry
- Previous by thread: failing 8.1.4 autovacuum
- Next by thread: Re: missing FROM-clause entry
- Indexes: