Re: BUG #15653: pg_detoast_datum_packed problem

Hi Andrew,

You are absolutely right and "select ", OID from ispp_wmpl where
(bvarchar (key))> = (bvarchar ('W' :: varchar)) and (bvarchar (key)) <=
(bvarchar ~~~~~~~~ ':: varchar)) order by key" has passed! However, pg
log file now has hundreds of warning message: 2019-03-09 10:53:29 CET
ispp-pionir-test :: 1 (53858) 14721 0 01000 WARNING: problem in
allocation set ExprContext: detected write past chunk end block
0x55ccb0b36468, chunk 0x55ccb0b36490 2019-03-09 10:53:29 CET
ispp-pionir-test :: 1 (53858) 14721 0 01000 WARNING: problem in
allocation set ExprContext: detected write past chunk end in block
0x55ccb0b36468, chunk 0x55ccb0b36490 2019-03-09 10:53:29 CET
ispp-pionir-test :: 1 (53858) 14721 0 01000 WARNING: problem in
allocation set ExprContext: detected write past chunk end in block
0x55ccb0b36468, chunk 0x55ccb0b36490 ... Andrew, I have to thank you for
this help because without this, my 'select' would never have passed. Vladimir Koković, DP senior(69)
Belgrade, Mar. 9 2019

On 9.3.19. 10:48, Andrew Gierth wrote:
>>>>>> "gmail" == gmail Vladimir Koković <vladimir(dot)kokovic(at)gmail(dot)com> writes:
> gmail> Hi Andrew.
> gmail> I changed VARSIZE to VARSIZE_ANY_EXHDR and VARDATA in
> gmail> VARDATA_ANY as you said, but there is still a problem I can not
> gmail> understand !
>
> Your message formatting was all messed up, but I can see that you are
> still subtracting VARHDRSZ - don't do that: VARSIZE_ANY_EXHDR already
> has the header size subtracted (hence "EXHDR"), it returns only the data
> size. (The header size is variable, 1 or 4 bytes, so it wouldn't make
> sense to include it.)
>