Bug in 7.1.3 and 7.2? - Mailing list pgsql-bugs

From Hans-Jürgen Schönig
Subject Bug in 7.1.3 and 7.2?
Date
Msg-id 3BEAA764.4D2AB9CC@cybertec.at
Whole thread Raw
Responses Re: Bug in 7.1.3 and 7.2?
Re: Bug in 7.1.3 and 7.2?
List pgsql-bugs
there seems to be a problem in 7.1.3 and 7.2:

test=# select * from a;id
---- 1 2 3
(3 rows)

test=# select * from b;id
---- 3 4
(2 rows)

test=# select a.*, d.* from a as c, b as d where a.id=b.id;
NOTICE:  Adding missing FROM-clause entry for table "a"
NOTICE:  Adding missing FROM-clause entry for table "b"id | id
----+---- 3 |  3 3 |  3 3 |  3 3 |  4 3 |  4 3 |  4
(6 rows)

Althoug c and d are aliases for a and b, the two tables are added to the

list in the from clause. Is this the desired behaviour or is it a bug?
   Hans



pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #511: multiple foreign keys on same table fail update cascade
Next
From: Vincent.Gaboriau@answare.fr
Date:
Subject: Curious problem with the character û é