Re: Altering a table - positioning new columns

From: "Chris Boget" <chris(at)wild(dot)net>
To: "Manfred Koizar" <mkoi-pg(at)aon(dot)at>
Cc: "PGSql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Altering a table - positioning new columns
Date: 2003-01-20 16:15:29
Message-ID: 02b101c2c09f$26d21370$8c01a8c0@ENTROPY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >I'm curious how difficult this would be to implement...
> The current implementation has the benefit that when you add a column
> existing tuples don't have to be touched.

Hmm, I was under the (obvious) (mis)understanding that a tuple was a
record. Is that not the case? If not, what is it, then?

> Each tuple header stores the number of attributes (natts) at the time of
> its creation. If you query for an attribute with a higher number, you get
> NULL. I don't think this can be changed easily without breaking lots of
> things.

How do the new columns fit into the above scheme?

Chris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2003-01-20 16:17:32 Re: Altering a table - positioning new columns
Previous Message Gregory Seidman 2003-01-20 16:14:56 Re: passwords and 7.3