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

2008-06-17 Thread m laks
--- On Tue, 6/17/08, Jaime Casanova <[EMAIL PROTECTED]> wrote: 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 Dear Jaime, Tommy's suggestion worked right away. I wanted to understand more of the philiosp

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

2008-06-17 Thread m laks
--- On Tue, 6/17/08, Tommy Gildseth <[EMAIL PROTECTED]> wrote: F How about something along these lines: delete from instancetable USING imagelevel WHERE ( (imagelevel.serparent= '1.2.840.113704.1.111.4640.1185891989.4') and (instancetable.imageuid= imagelevel.sopinsuid) ) Thank You so muc

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

2008-06-16 Thread m laks
Hi, I am migrating to postgresql 8.1 from 7.4 with debian. Now I notice that one of my perl DBI scripts is crashing with the error above, and worked fine before. >From google I learn that postgresql is  getting tougher on us malfeasant >coders who violate the SQL rules :(.  I have not slept