Re: BUG #4747: Some type names accepted in place of column name. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4747: Some type names accepted in place of column name.
Date
Msg-id 10629.1238614467@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4747: Some type names accepted in place of column name.  ("Bruce Toll" <btoll@dhsus.com>)
List pgsql-bugs
"Bruce Toll" <btoll@dhsus.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

pgsql-bugs by date:

Previous
From: "Bruce Toll"
Date:
Subject: BUG #4747: Some type names accepted in place of column name.
Next
From: Beto Piragauta
Date:
Subject: consulta de phpESP postgres error