

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] 
> Sent: 04 July 2002 07:40
> To: Tom Lane
> Cc: Christopher Kings-Lynne; Hiroshi Inoue; Hackers
> Subject: Re: [HACKERS] BETWEEN Node & DROP COLUMN
> 
> 
> Well, why shouldn't we use the fact that most/all clients 
> don't look at attno < 0, and that we have no intention of 
> changing that requirement. 
> We aren't coding in a vacuum.  We have clients, they do that 
> already, let's use it.

Just to chuck my $0.02 in the pot:

pgAdmin will require modification not matter which route is taken. It
*does* look at columns with negative attnums whenever the user switches
on the 'View System Objects' option which un-hides the pg_*
tables/views, columns with attnums < 1, template1 and more.

From my pov, the least painful route would be to add the attisdropped
column. I can add a check to this far more easily than messing about
with losing columns where attnum < -7 - especially, if in a future
release of PostgreSQL the number of columns like tableoid, xid etc
changes.

Personnally, from a not caring about how it works, just how it's
presented perspective, attisdropped seems much cleaner to me.

I also agree with Christopher - compared to the work the addition of
schemas required (~50 hours in pgAdmin) this is a 2 minute job!

Well, that was more like $0.10....

Regards, Dave.



Thu, 4 Jul 2002 10:18:02 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: BETWEEN Node & DROP COLUMN