Weirdness with OIDs and JOIN ON?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Weirdness with OIDs and JOIN ON?
Date: 2004-04-28 07:22:32
Message-ID: 408F5BB8.4060503@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Why doesn't this work:

test=# select oid, relname, indisclustered from pg_index join pg_class
on indexrelid=oid where indexrelid > 17205;
ERROR: column "oid" does not exist

I'm _joining_ on the oid column.

If I qualify it, it works:

test=# select pg_class.oid, relname, indisclustered from pg_index join
pg_class on indexrelid=oid where indexrelid > 17205;
oid | relname | indisclustered
-------+--------------+----------------
17214 | child_b_key | t
17210 | parent_a_key | t
(2 rows)

I can't see that I've made an error in the first example - is it a
Postgres bug?

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-04-28 07:38:44 Re: Nasty security bug with clustering
Previous Message Christopher Kings-Lynne 2004-04-28 07:07:59 Re: bitwise and/or aggregate functions?