1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
-- 64 bit output in *.out, 32 bit output in *_3.out
-- PG12+ output in *.out/*_3.out, earlier in *_1.out/*_4.out
select oid as datoid from pg_database where datname = current_database() \gset
----------------------------------------------------------------------------------------------
create table float4 (x float4);
insert into float4 values (0), ('-0'), ('-infinity'), ('infinity'), ('NaN'), (null);
\set relname float4
\ir run_test.sql
\echo Testing :relname
Testing float4
vacuum :"relname";
checkpoint;
select relfilenode from pg_class where relname = :'relname' \gset
select lo_import(format('base/%s/%s', :'datoid', :'relfilenode')) as oid \gset
\set output :relname '.heap'
\lo_export :oid :output
\setenv relname :relname
\! pg_filedump -D $relname $relname.heap | ./sed.sh
*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: float4.heap
* Options used: -D float4
*******************************************************************
Block 0 ********************************************************
<Header> -----
Block Offset: 0x00000000 Offsets: Lower 48 (0x0030)
Block: Size 8192 Version 4 Upper 8008 (0x1f48)
LSN: logid ...... recoff 0x........ Special 8192 (0x2000)
Items: 6 Free Space: 7960
Checksum: 0x.... Prune XID: 0x00000000 Flags: 0x0004 (ALL_VISIBLE)
Length (including item array): 48
<Data> -----
Item 1 -- Length: 28 Offset: 8160 (0x1fe0) Flags: NORMAL
COPY: 0.000000000000
Item 2 -- Length: 28 Offset: 8128 (0x1fc0) Flags: NORMAL
COPY: -0.000000000000
Item 3 -- Length: 28 Offset: 8096 (0x1fa0) Flags: NORMAL
COPY: -Infinity
Item 4 -- Length: 28 Offset: 8064 (0x1f80) Flags: NORMAL
COPY: Infinity
Item 5 -- Length: 28 Offset: 8032 (0x1f60) Flags: NORMAL
COPY: NaN
Item 6 -- Length: 24 Offset: 8008 (0x1f48) Flags: NORMAL
COPY: \N
*** End of File Encountered. Last Block Read: 0 ***
--
----------------------------------------------------------------------------------------------
--
create table float8 (x float8);
insert into float8 values (0), ('-0'), ('-infinity'), ('infinity'), ('NaN'), (null);
\set relname float8
\ir run_test.sql
\echo Testing :relname
Testing float8
vacuum :"relname";
checkpoint;
select relfilenode from pg_class where relname = :'relname' \gset
select lo_import(format('base/%s/%s', :'datoid', :'relfilenode')) as oid \gset
\set output :relname '.heap'
\lo_export :oid :output
\setenv relname :relname
\! pg_filedump -D $relname $relname.heap | ./sed.sh
*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: float8.heap
* Options used: -D float8
*******************************************************************
Block 0 ********************************************************
<Header> -----
Block Offset: 0x00000000 Offsets: Lower 48 (0x0030)
Block: Size 8192 Version 4 Upper 8008 (0x1f48)
LSN: logid ...... recoff 0x........ Special 8192 (0x2000)
Items: 6 Free Space: 7960
Checksum: 0x.... Prune XID: 0x00000000 Flags: 0x0004 (ALL_VISIBLE)
Length (including item array): 48
<Data> -----
Item 1 -- Length: 32 Offset: 8160 (0x1fe0) Flags: NORMAL
COPY: 0.000000000000
Item 2 -- Length: 32 Offset: 8128 (0x1fc0) Flags: NORMAL
COPY: -0.000000000000
Item 3 -- Length: 32 Offset: 8096 (0x1fa0) Flags: NORMAL
COPY: -Infinity
Item 4 -- Length: 32 Offset: 8064 (0x1f80) Flags: NORMAL
COPY: Infinity
Item 5 -- Length: 32 Offset: 8032 (0x1f60) Flags: NORMAL
COPY: NaN
Item 6 -- Length: 24 Offset: 8008 (0x1f48) Flags: NORMAL
COPY: \N
*** End of File Encountered. Last Block Read: 0 ***
--
----------------------------------------------------------------------------------------------
--
|
