Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4295: DELETE WHERE Condition - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #4295: DELETE WHERE Condition
Date
Msg-id 200807111040.00823.peter_e@gmx.net
Whole thread Raw
In response to BUG #4295: DELETE WHERE Condition  ("Fred Perniss" <perniss@zks-gmbh.de>)
List pgsql-bugs
Tree view 
Am Freitag, 11. Juli 2008 schrieb Fred Perniss:
> In Postgres the switch add_mising_from=on the SQL-Command
>
> DELETE FROM t2
> WHERE (t2.t2_t1_id=t1.t1_id)
> AND t1.t1_inhalt=5
> ;
>
> works (with message in Log).
>
> If the switch add_missing_from=off following Error-Message will be promted:
>
> Fehlender Eintrag in FROM Klausel für Tabelle t1

You want to use DELETE .. USING.  See the man page for details.

pgsql-bugs by date:

Previous
From: "Fred Perniss"
Date:
Subject: BUG #4295: DELETE WHERE Condition
Next
From: "Michal Szelag"
Date:
Subject: BUG #4296: Server crashes by restoring database