Re: DROP COLUMN

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Rod Taylor <rbt(at)zort(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP COLUMN
Date: 2002-07-17 04:11:42
Message-ID: 3D34EE7E.59246094@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
>
> Hiroshi Inoue wrote:
> > Bruce Momjian wrote:
> > >
> > > Hiroshi Inoue wrote:
>
> > > > BTW would we do nothing for clients after all ?
> > >
> > > Clients will now need to check that dropped flag.
> >
> > Clients would have to check the flag everywhere
> > pg_attribute appears.
> > Why should clients do such a thing ?
>
> Well, good question. They could easily skip the dropped columns if we
> used negative attno's because they usually already skip system columns.
> However, they prefered a specific dropped column flag and positive
> attno's. I don't know why. They would have to explain.

I don't stick to negative attno's but

> >From my perspective, when client coders like Dave Page and others say
> they would prefer the flag to the negative attno's, I don't have to
> understand. I just take their word for it.

do they really love to check attisdropped everywhere ?
Isn't it the opposite of the encapsulation ?
I don't understand why we would do nothing for clients.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-07-17 04:13:09 Re: DROP COLUMN
Previous Message Tom Lane 2002-07-17 04:10:31 Re: Do we still need these NOTICEs?