From: | "Michael Richards" <miker(at)interchange(dot)ca> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Tuple data |
Date: | 2000-12-16 19:33:22 |
Message-ID: | 04d601c06797$0d6fd790$0200a8c0@digitallis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi.
I've still got something I can't seem to get. In my test cases with simple
tables the first uint16 of tuple data after the header contained the length
of the tuple. In this case I can't seem to figure out what the value F24D
stands for when I'd expect it's length to be 0800.
The first tuple in my table has:
OID: 6155665
t_cmin: 32494973
t_cmax: 0
t_xmin: 32494324
t_xmax: 32495742
t_ctid: 55181312:82
t_infomask: A503
Bitmap: 3F00000000F2
Attributes: 7
Data Offset: 36
The flags for this tuple say:
HEAP_MOVED_IN
HEAP_UPDATED
HEAP_XMAX_COMMITTED
HEAP_XMIN_INVALID
HEAP_HASVARLENA
HEAP_HASNULL
Tuple Data:
F24D 0000 FFFF FFFF 1300 0000 4E65 7720 4D61 696C 2046 6F6C 6465 7200
9F00 0000 9F00 0000 48A2 1800
The schema is:
Attribute | Type | Modifier
-------------+-------------+------------------------------------------------
--------
userid | integer | not null
folderid | integer | not null default
nextval('folders_folderid_seq'::text)
foldername | varchar(25) |
messages | integer |
newmessages | integer |
foldersize | integer |
popinfo | integer |
Indices: folder_folderid_idx,
folders_pkey
thanks
-Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-16 19:57:03 | Re: Tuple data |
Previous Message | Peter Eisentraut | 2000-12-16 18:24:01 | Re: shared libs on sco how? |