Thanks a lot!
It works!
Regards,
Kaloyan Iliev
Tom Lane wrote:
Kaloyan Iliev <[EMAIL PROTECTED]> writes:
rsr=# SELECT
...
rsr-# FROM debts_desc DD LEFT JOIN config
C ON (DD.conf_id = C.id),
...
rsr-# FOR UPDATE OF
debts_desc;
ERROR: relation "debts_desc" in FOR UPDATE/SHARE clause not found in
FROM clause
Use the alias, ie, DD. Remember that an alias hides the real name of
that table for all purposes in the current query.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
