From: | "Fred Perniss" <perniss(at)zks-gmbh(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4295: DELETE WHERE Condition |
Date: | 2008-07-11 07:34:16 |
Message-ID: | 200807110734.m6B7YGOc034656@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4295
Logged by: Fred Perniss
Email address: perniss(at)zks-gmbh(dot)de
PostgreSQL version: all Versions
Operating system: Open SuSe Linux 11
Description: DELETE WHERE Condition
Details:
Fist: Sorry for my bad english.
I have 2 tables
table t1 with fields t1.t1_id, t1.t1_value
table t2 with fields t2.t2_id, t2.t2_t1_id, t2.t2_value
table t2 have a forign key to table t1 (t2_t1_id)
I have to delete all rows from table t2 with the condition t1.t1_value = 5.
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
The new Syntax from SQL in MySQL Version 4
DELETE FROM T2 FROM t1, t2
WHERE (t2.t2_t1_id=t1.t1_id)
AND t1.t1_inhalt=5
;
is not implemented.
I don't find any other Syntax for this and I don't find any in the log, how
I can change the sytax or how postgre do this if the switch add_mising_from
is on.
Can you tell me the correct syntax or can you tell me how the server
transform the query if the switch is set to on?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-07-11 08:39:58 | Re: BUG #4295: DELETE WHERE Condition |
Previous Message | Tom Lane | 2008-07-11 04:28:14 | Re: BUG #4294: XML support: name() xpath function not working |