Re: [HACKERS] Last thoughts about LONG

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Jan Wieck <wieck(at)debis(dot)com>
Cc: pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Last thoughts about LONG
Date: 1999-12-11 19:29:15
Message-ID: 3852A60B.577E39DB@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan Wieck wrote:
>
> - At CREATE TABLE, a long value relation named
> "_LONG<tablename>" is created for those tables who need it.
> And of course dropped and truncated appropriate. The schema
> of this table is
>
> rowid Oid, -- oid of our main data row
> rowattno int2, -- the attribute number in main data
> chunk_seq int4, -- the part number of this data chunk
> chunk text -- the content of this data chunk
>
> There is a unique index defined on (rowid, rowattno).
>

If you plan to use the same LONGs for multiple versions you will probably
need a refcount int4 too

--------------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 1999-12-11 19:39:05 Re: [HACKERS] LONG
Previous Message Hannu Krosing 1999-12-11 19:22:29 Re: [HACKERS] Last thoughts about LONG