Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit13e0d7a

Browse files
committed
Rename pg_dissect_walfile_name() to pg_split_walfile_name()
The former name was discussed as being confusing, so use "split", as pera suggestion from Magnus Hagander.While on it, one of the output arguments is renamed from "segno" to"segment_number", as per a suggestion from Kyotaro Horiguchi.The documentation is updated to reflect all these changes.Bump catalog version.Author: Bharath Rupireddy, Michael PaquierDiscussion:https://postgr.es/m/CABUevEytQVaOOhGdoh0D7hGwe3fuKcRF6NthsSW7ww04EmtFgQ@mail.gmail.com
1 parented1a88d commit13e0d7a

File tree

6 files changed

+41
-41
lines changed

6 files changed

+41
-41
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -26101,15 +26101,15 @@ LOG: Grand total: 1651920 bytes in 201 blocks; 622360 free (88 chunks); 1029560
2610126101
<row>
2610226102
<entry role="func_table_entry"><para role="func_signature">
2610326103
<indexterm>
26104-
<primary>pg_dissect_walfile_name</primary>
26104+
<primary>pg_split_walfile_name</primary>
2610526105
</indexterm>
26106-
<function>pg_dissect_walfile_name</function> ( <parameter>file_name</parameter> <type>text</type> )
26106+
<function>pg_split_walfile_name</function> ( <parameter>file_name</parameter> <type>text</type> )
2610726107
<returnvalue>record</returnvalue>
26108-
( <parameter>segno</parameter> <type>numeric</type>,
26108+
( <parameter>segment_number</parameter> <type>numeric</type>,
2610926109
<parameter>timeline_id</parameter> <type>bigint</type> )
2611026110
</para>
2611126111
<para>
26112-
Extracts thefilesequence number and timeline ID from a WAL file
26112+
Extracts the sequence number and timeline ID from a WAL file
2611326113
name.
2611426114
</para></entry>
2611526115
</row>
@@ -26172,13 +26172,13 @@ postgres=# SELECT * FROM pg_walfile_name_offset((pg_backup_stop()).lsn);
2617226172
</para>
2617326173

2617426174
<para>
26175-
<function>pg_dissect_walfile_name</function> is useful to compute a
26175+
<function>pg_split_walfile_name</function> is useful to compute a
2617626176
<acronym>LSN</acronym> from a file offset and WAL file name, for example:
2617726177
<programlisting>
2617826178
postgres=# \set file_name '000000010000000100C000AB'
2617926179
postgres=# \set offset 256
26180-
postgres=# SELECT '0/0'::pg_lsn + pd.segno * ps.setting::int + :offset AS lsn
26181-
FROMpg_dissect_walfile_name(:'file_name') pd,
26180+
postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset AS lsn
26181+
FROMpg_split_walfile_name(:'file_name') pd,
2618226182
pg_show_all_settings() ps
2618326183
WHERE ps.name = 'wal_segment_size';
2618426184
lsn

‎src/backend/access/transam/xlogfuncs.c

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -437,16 +437,16 @@ pg_walfile_name(PG_FUNCTION_ARGS)
437437
* name.
438438
*/
439439
Datum
440-
pg_dissect_walfile_name(PG_FUNCTION_ARGS)
440+
pg_split_walfile_name(PG_FUNCTION_ARGS)
441441
{
442-
#definePG_DISSECT_WALFILE_NAME_COLS 2
442+
#definePG_SPLIT_WALFILE_NAME_COLS 2
443443
char*fname=text_to_cstring(PG_GETARG_TEXT_PP(0));
444444
char*fname_upper;
445445
char*p;
446446
TimeLineIDtli;
447447
XLogSegNosegno;
448-
Datumvalues[PG_DISSECT_WALFILE_NAME_COLS]= {0};
449-
boolisnull[PG_DISSECT_WALFILE_NAME_COLS]= {0};
448+
Datumvalues[PG_SPLIT_WALFILE_NAME_COLS]= {0};
449+
boolisnull[PG_SPLIT_WALFILE_NAME_COLS]= {0};
450450
TupleDesctupdesc;
451451
HeapTupletuple;
452452
charbuf[256];
@@ -482,7 +482,7 @@ pg_dissect_walfile_name(PG_FUNCTION_ARGS)
482482

483483
PG_RETURN_DATUM(result);
484484

485-
#undefPG_DISSECT_WALFILE_NAME_COLS
485+
#undefPG_SPLIT_WALFILE_NAME_COLS
486486
}
487487

488488
/*

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -57,6 +57,6 @@
5757
*/
5858

5959
/*yyyymmddN */
60-
#defineCATALOG_VERSION_NO202212231
60+
#defineCATALOG_VERSION_NO202212232
6161

6262
#endif

‎src/include/catalog/pg_proc.dat

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -6374,11 +6374,11 @@
63746374
prosrc => 'pg_walfile_name' },
63756375
{ oid => '8205',
63766376
descr => 'sequence number and timeline ID given a wal filename',
6377-
proname => 'pg_dissect_walfile_name', provolatile => 's',
6377+
proname => 'pg_split_walfile_name', provolatile => 's',
63786378
prorettype => 'record', proargtypes => 'text',
63796379
proallargtypes => '{text,numeric,int8}', proargmodes => '{i,o,o}',
6380-
proargnames => '{file_name,segno,timeline_id}',
6381-
prosrc => 'pg_dissect_walfile_name' },
6380+
proargnames => '{file_name,segment_number,timeline_id}',
6381+
prosrc => 'pg_split_walfile_name' },
63826382

63836383
{ oid => '3165', descr => 'difference in bytes, given two wal locations',
63846384
proname => 'pg_wal_lsn_diff', prorettype => 'numeric',

‎src/test/regress/expected/misc_functions.out

Lines changed: 18 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -619,26 +619,26 @@ SELECT count(*) > 0 AS ok FROM pg_control_system();
619619
t
620620
(1 row)
621621

622-
--pg_dissect_walfile_name
623-
SELECT * FROMpg_dissect_walfile_name(NULL);
624-
segno | timeline_id
625-
-------+-------------
626-
|
622+
--pg_split_walfile_name
623+
SELECT * FROMpg_split_walfile_name(NULL);
624+
segment_number | timeline_id
625+
----------------+-------------
626+
|
627627
(1 row)
628628

629-
SELECT * FROMpg_dissect_walfile_name('invalid');
629+
SELECT * FROMpg_split_walfile_name('invalid');
630630
ERROR: invalid WAL file name "invalid"
631-
SELECTsegno > 0 ASok_segno, timeline_id
632-
FROMpg_dissect_walfile_name('000000010000000100000000');
633-
ok_segno | timeline_id
634-
----------+-------------
635-
t | 1
636-
(1 row)
637-
638-
SELECTsegno > 0 ASok_segno, timeline_id
639-
FROMpg_dissect_walfile_name('ffffffFF00000001000000af');
640-
ok_segno | timeline_id
641-
----------+-------------
642-
t | 4294967295
631+
SELECTsegment_number > 0 ASok_segment_number, timeline_id
632+
FROMpg_split_walfile_name('000000010000000100000000');
633+
ok_segment_number | timeline_id
634+
-------------------+-------------
635+
t| 1
636+
(1 row)
637+
638+
SELECTsegment_number > 0 ASok_segment_number, timeline_id
639+
FROMpg_split_walfile_name('ffffffFF00000001000000af');
640+
ok_segment_number | timeline_id
641+
-------------------+-------------
642+
t| 4294967295
643643
(1 row)
644644

‎src/test/regress/sql/misc_functions.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -230,10 +230,10 @@ SELECT count(*) > 0 AS ok FROM pg_control_init();
230230
SELECTcount(*)>0AS okFROM pg_control_recovery();
231231
SELECTcount(*)>0AS okFROM pg_control_system();
232232

233-
--pg_dissect_walfile_name
234-
SELECT*FROMpg_dissect_walfile_name(NULL);
235-
SELECT*FROMpg_dissect_walfile_name('invalid');
236-
SELECTsegno>0ASok_segno, timeline_id
237-
FROMpg_dissect_walfile_name('000000010000000100000000');
238-
SELECTsegno>0ASok_segno, timeline_id
239-
FROMpg_dissect_walfile_name('ffffffFF00000001000000af');
233+
--pg_split_walfile_name
234+
SELECT*FROMpg_split_walfile_name(NULL);
235+
SELECT*FROMpg_split_walfile_name('invalid');
236+
SELECTsegment_number>0ASok_segment_number, timeline_id
237+
FROMpg_split_walfile_name('000000010000000100000000');
238+
SELECTsegment_number>0ASok_segment_number, timeline_id
239+
FROMpg_split_walfile_name('ffffffFF00000001000000af');

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp