Re: BUG #3876: Problems migrating databases

On Jan 15, 2008 5:52 PM, Ruben Camargo Gomez
<rubencamargogomez@hotmail.com> wrote:
> I had this error from my log file:
> ERRORROR:  missing FROM-clause entry for table "tbldishot"
> CONTEXT:  SQL statement "update tblalohot set  alohot_con =
> coalesce(alohot_con,0)+8 where tbldishot.dishot_cod = tblalohot.dishot_cod
> and tbldishot.establ_cod = 8699 and tbldishot.tiphah_cod=7 and
> tblalohot.establ_cod = 7713 and tbldishot.dishot_fec >= '2007-10-23' and
> tbldishot.dishot_fec < '2007-10-24'"
>         PL/pgSQL function "fun_reg_dis" line 34 at

Prior to 8.1, PostgreSQL adds tables missing in the FROM clause
automatically. This behaviour has been removed because it could lead
to unexpected results.

You should fix your query by using the UPDATE FROM syntax and by
having tbldishot in the FROM clause. You have several enlightening
examples in http://www.postgresql.org/docs/8.1/static/sql-update.html
.

You can also use add_missing_from = on in your postgresql.conf if you
really can't fix your query but it's not recommended.

--
Guillaume