Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value - Mailing list pgsql-hackers

From jian he
Subject Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value
Date
Msg-id CACJufxHG5iVGkCoARLMQypBUy_k0VmahPdHwRCk75Nm3NxcwZw@mail.gmail.com
Whole thread Raw
In response to Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value
List pgsql-hackers
minor doc issues.
Returns the chunk id of the TOASTed value, or NULL if the value is not TOASTed.
Should it be "chunk_id"?

you may place it after pg_create_logical_replication_slot entry to
make it look like alphabetical order.

There is no test. maybe we can add following to src/test/regress/sql/misc.sql
create table val(t text);
INSERT into val(t) SELECT string_agg(
  chr((ascii('B') + round(random() * 25)) :: integer),'')
FROM generate_series(1,2500);
select pg_column_toast_chunk_id(t) is  not null from val;
drop table val;



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Something seems weird inside tts_virtual_copyslot()
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Synchronizing slots from primary to standby