On Tue, Jun 17, 2008 at 1:25 AM, m laks <[EMAIL PROTECTED]> wrote: > Hi, > I am migrating to postgresql 8.1 from 7.4 with debian. > [...] > > the following worked before: > > LTA_IDB=# delete from instancetable where ( (imagelevel.serparent= > '1.2.840.113704.1.111.4640.1185891989.4') and (instancetable.imageuid= > imagelevel.sopinsuid)); (at least in postgresql 7.4 using perl DBI). > > It worked on postgresql 7.4 and now on postgresql 8.1 I get error: > > ERROR: missing FROM-clause entry for table "imagelevel" >
maybe the add_missing_from parameter in postgresql.conf is what you need to get some sleep :) it's there for older application like yours -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
