Re: BUG #4747: Some type names accepted in place of column name.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bruce Toll" <btoll(at)dhsus(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4747: Some type names accepted in place of column name.
Date: 2009-04-01 19:34:27
Message-ID: 10629.1238614467@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Bruce Toll" <btoll(at)dhsus(dot)com> writes:
> For instance, the pg_catalog.pg_class table has no
> column "name", yet the following query returns rows from the pg_class
> table:

> SELECT pg_class.name FROM pg_class limit 2;
> name
> -----------------------------------------------------------------
> (pg_type,11,71,10,0,1247,0,62,676,0,0,t,f,r,28,0,t,f,f,f,f,648,
> (pg_attribute,11,75,10,0,1249,0,587,6145,0,0,t,f,r,18,0,f,f,f,f
> (2 rows)

Well, this is documented to be treated like name(pg_class), so
I'm really not convinced that we should consider this a bug.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Beto Piragauta 2009-04-01 21:08:15 consulta de phpESP postgres error
Previous Message Bruce Toll 2009-04-01 18:55:42 BUG #4747: Some type names accepted in place of column name.