Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: mlaks2000(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join
Date: 2008-06-17 06:32:10
Message-ID: c2d9e70e0806162332y61abf763s7a0ffbd4c73edb91@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 17, 2008 at 1:25 AM, m laks <mlaks2000(at)yahoo(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tommy Gildseth 2008-06-17 06:32:19 Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join
Previous Message m laks 2008-06-17 06:25:19 ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join