Tuple data - Mailing list pgsql-hackers

From Michael Richards
Subject Tuple data
Date
Msg-id 04d601c06797$0d6fd790$0200a8c0@digitallis
Whole thread Raw
Responses Re: Tuple data
List 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 nullfolderid    | 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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: shared libs on sco how?
Next
From: Tom Lane
Date:
Subject: Re: Tuple data