BUG #2789: problem with delete statement

The following bug has been logged online:

Bug reference: 2789
Logged by: Lucian Capdefier
Email address: luciancapdefier(at)gmail(dot)com
PostgreSQL version: 8.1.5
Operating system: Windows XP
Description: problem with delete statement
Details:

I have noticed a problem with the DELETE statement.

1. I cannot user table alias in the FROM clause of the DELETE statement.
2. I cannot user more than one, table in the FROM clause.

Example:

1.
delete
from fxkanban.product_offer
where offer_id=1 and
exists (select 1 from fxkanban.product_offer x, fxkanban.product p
where x.product_id=p.product_id and
x.offer_id=offer_id and
p.owner='test')
works ok

delete
from fxkanban.product_offer o
where o.offer_id=1 and
exists (select 1 from fxkanban.product_offer x, fxkanban.product p
where x.product_id=p.product_id and
x.offer_id=o.offer_id and
p.owner='test')
does not work

2.
delete
from only fxkanban.product_offer, fxkanban.product p
where o.offer_id=1 and
o.product_id=p.product_id and
p.owner='test'
does not work

Both problems issue SQL Error 42601