Re: 'natural join' core dump

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Mark Hollomon" <mhh@nortelnetworks.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2000-06-26T22:33:56Z
Lists: pgsql-hackers
"Mark Hollomon" <mhh@nortelnetworks.com> writes:
> -- core dumps
> select * from a natural join b natural join c;
> -- so does this
> select * from a join b using (b) join c using (c);
> -- this seems to work
> select * from a join b on a.b = b.b join c on b.c = c.c;

This is a previously reported problem that's on Thomas' todo list.

			regards, tom lane