Weirdness with OIDs and JOIN ON?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Weirdness with OIDs and JOIN ON?
Дата
Msg-id 408F5BB8.4060503@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Weirdness with OIDs and JOIN ON?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: bitwise and/or aggregate functions?
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Nasty security bug with clustering