Re: [HACKERS] Last thoughts about LONG - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] Last thoughts about LONG
Date
Msg-id 3852A60B.577E39DB@tm.ee
Whole thread Raw
In response to Last thoughts about LONG  (wieck@debis.com (Jan Wieck))
List 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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Last thoughts about LONG
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] LONG