Re: ALTER TABLE DROP COLUMN

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: ALTER TABLE DROP COLUMN
Date: 2000-10-06 03:05:58
Message-ID: 39DD4196.766DFC01@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> >>>> P.S. I've noticed that get_rte_attribute_name() seems to
> >>>> break my implementation. I'm not sure if I could solve it.
> >>
> >> That would be a problem --- rule dumping depends on that code to
> >> produce correct aliases, so making it work is not optional.
>
> > Your change has no problem if logical==physical attribute
> > numbers.
>
> But if they're not, what do we do? Can we define the order of the
> alias-name lists as being one or the other numbering? (Offhand I'd
> say it should be logical numbering, but I haven't chased the details.)
> If neither of those work, we'll need some more complex datastructure
> than a simple list.
>

I'm not sure if we could keep invariant attribute numbers.
Though I've used physical attribute numbers as many as possible
in my trial implementation,there's already an exception.
I had to use logical attribute numbers for FieldSelect node.

Regards.

Hiroshi Inoue

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-10-06 04:26:24 Re: ALTER TABLE DROP COLUMN
Previous Message Tom Lane 2000-10-06 02:42:42 Re: ALTER TABLE DROP COLUMN