View Single Post

   
  #4 (permalink)  
Old 04-11-2008, 02:47 AM
Robert Treat
 
Posts: n/a
Default Re: Get rid of system attributes in pg_attribute?

On Saturday 19 February 2005 12:17, Tom Lane wrote:
> Andreas Pflug <pgadmin@pse-consulting.de> writes:
> >>> Does anyone know of client code that actually pays attention to
> >>> pg_attribute rows with negative attnums?

> >
> > Would those columns remain selectable for debugging/maintenance
> > purposes, despite not appearing in system catalogs?

>
> Certainly. They just wouldn't have entries in pg_attribute.
>


If I am understanding this correctly, they could only be displayed if selected
explicitly right? So any program that attempts to show all "hidden" columns
by just doing a "where attnum < 1" is going to break, correct?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote