Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group