Re: More Tuple Madness - Mailing list pgsql-hackers

From Tom Lane
Subject Re: More Tuple Madness
Date
Msg-id 21059.977076889@sss.pgh.pa.us
Whole thread Raw
In response to More Tuple Madness  ("Michael Richards" <miker@interchange.ca>)
List pgsql-hackers
"Michael Richards" <miker@interchange.ca> writes:
> The alignment seems to be wrong for type CHAR(1):

No, the alignment is fine.  A field's align constraint says where it has
to start, not where the next field has to start.  gender starts on a
4-byte boundary and is 5 bytes long, then we have one byte wasted for
alignment of yearofbirth, then yearofbirth starts on a 2-byte boundary.
Everyone's happy.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table name scope (was Re: [BUGS] Outer joins aren't working with views)
Next
From: Peter Eisentraut
Date:
Subject: pg_dumpall --accounts-only