⊟
508 KB
/srv/reproducible-results/rbuild-debian/r-b-build.XsUT6dp8/b1/postgis_3.5.2+dfsg-1_amd64.changes vs.
/srv/reproducible-results/rbuild-debian/r-b-build.XsUT6dp8/b2/postgis_3.5.2+dfsg-1_amd64.changes
⊟
943 B
Files
    
Offset 1, 9 lines modifiedOffset 1, 9 lines modified
  
1 ·b40b55459caab46b0bc158fc9b00e9c1·550660·debug·optional·postgis-dbgsym_3.5.2+dfsg-1_amd64.deb1 ·b40b55459caab46b0bc158fc9b00e9c1·550660·debug·optional·postgis-dbgsym_3.5.2+dfsg-1_amd64.deb
2 ·7f9155ce6b089ff240e14d566489e93a·3079136·doc·optional·postgis-doc_3.5.2+dfsg-1_all.deb2 ·7f9155ce6b089ff240e14d566489e93a·3079136·doc·optional·postgis-doc_3.5.2+dfsg-1_all.deb
3 ·4afd166af9662624dc4baffa480c3132·153452·misc·optional·postgis_3.5.2+dfsg-1_amd64.deb3 ·4afd166af9662624dc4baffa480c3132·153452·misc·optional·postgis_3.5.2+dfsg-1_amd64.deb
4 ·4289ddbd14d6eccb1ce97e544a090c24·4348572·debug·optional·postgresql-17-postgis-3-dbgsym_3.5.2+dfsg-1_amd64.deb4 ·4289ddbd14d6eccb1ce97e544a090c24·4348572·debug·optional·postgresql-17-postgis-3-dbgsym_3.5.2+dfsg-1_amd64.deb
5 ·9d44ebba049f09f646037e99a69d4e6f·1275708·misc·optional·postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb5 ·7a4268239d9e9ae84fef597f482a77e1·1278276·misc·optional·postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb
6 ·b9946cc9317442764e8c314e65fd1170·3598712·misc·optional·postgresql-17-postgis-3_3.5.2+dfsg-1_amd64.deb6 ·b9946cc9317442764e8c314e65fd1170·3598712·misc·optional·postgresql-17-postgis-3_3.5.2+dfsg-1_amd64.deb
7 ·b9dabb5fad3251994de7a0d489ddbe76·20968·misc·optional·postgresql-postgis-scripts_3.5.2+dfsg-1_all.deb7 ·b9dabb5fad3251994de7a0d489ddbe76·20968·misc·optional·postgresql-postgis-scripts_3.5.2+dfsg-1_all.deb
8 ·e189dabef517e781fabb883f7d9ee0ed·20944·metapackages·optional·postgresql-postgis_3.5.2+dfsg-1_amd64.deb8 ·e189dabef517e781fabb883f7d9ee0ed·20944·metapackages·optional·postgresql-postgis_3.5.2+dfsg-1_amd64.deb
⊟
507 KB
postgresql-17-postgis-3-scripts_3.5.2+dfsg-1_all.deb
⊟
452 B
file list
    
Offset 1, 3 lines modifiedOffset 1, 3 lines modified
1 -rw-r--r--···0········0········0········4·2025-01-19·06:35:59.000000·debian-binary1 -rw-r--r--···0········0········0········4·2025-01-19·06:35:59.000000·debian-binary
2 -rw-r--r--···0········0········0·····2724·2025-01-19·06:35:59.000000·control.tar.xz2 -rw-r--r--···0········0········0·····2720·2025-01-19·06:35:59.000000·control.tar.xz
3 -rw-r--r--···0········0········0··1272792·2025-01-19·06:35:59.000000·data.tar.xz3 -rw-r--r--···0········0········0··1275364·2025-01-19·06:35:59.000000·data.tar.xz
⊟
595 B
control.tar.xz
⊟
567 B
control.tar
⊟
497 B
./control
    
Offset 1, 13 lines modifiedOffset 1, 13 lines modified
1 Package:·postgresql-17-postgis-3-scripts1 Package:·postgresql-17-postgis-3-scripts
2 Source:·postgis2 Source:·postgis
3 Version:·3.5.2+dfsg-13 Version:·3.5.2+dfsg-1
4 Architecture:·all4 Architecture:·all
5 Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org>5 Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org>
6 Installed-Size:·380646 Installed-Size:·38556
7 Recommends:·postgresql-17-postgis-37 Recommends:·postgresql-17-postgis-3
8 Provides:·postgresql-17-postgis-scripts8 Provides:·postgresql-17-postgis-scripts
9 Section:·misc9 Section:·misc
10 Priority:·optional10 Priority:·optional
11 Multi-Arch:·foreign11 Multi-Arch:·foreign
12 Homepage:·https://postgis.net/12 Homepage:·https://postgis.net/
13 Description:·Geographic·objects·support·for·PostgreSQL·17·--·SQL·scripts13 Description:·Geographic·objects·support·for·PostgreSQL·17·--·SQL·scripts
⊟
48.0 B
./md5sums
⊟
30.0 B
./md5sums
Files differ
⊟
506 KB
data.tar.xz
⊟
506 KB
data.tar
⊟
2.53 KB
file list
    
Offset 40, 15 lines modifiedOffset 40, 15 lines modified
40 -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--3.5.2.sql40 -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--3.5.2.sql
41 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--ANY--3.5.2.sql41 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--ANY--3.5.2.sql
42 -rw-r--r--···0·root·········(0)·root·········(0)······135·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--TEMPLATED--TO--ANY.sql42 -rw-r--r--···0·root·········(0)·root·········(0)······135·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer--TEMPLATED--TO--ANY.sql
43 -rw-r--r--···0·root·········(0)·root·········(0)······206·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer-3.control43 -rw-r--r--···0·root·········(0)·root·········(0)······206·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer-3.control
44 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2--3.5.2next.sql44 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2--3.5.2next.sql
45 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2.sql45 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2.sql
46 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2next--3.5.2.sql46 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--3.5.2next--3.5.2.sql
47 -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql47 -rw-r--r--···0·root·········(0)·root·········(0)···505113·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql
48 -rw-r--r--···0·root·········(0)·root·········(0)······151·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql48 -rw-r--r--···0·root·········(0)·root·········(0)······151·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql
49 -rw-r--r--···0·root·········(0)·root·········(0)······131·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us-3.control49 -rw-r--r--···0·root·········(0)·root·········(0)······131·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/address_standardizer_data_us-3.control
50 -rw-r--r--···0·root·········(0)·root·········(0)··7477406·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--3.5.2.sql50 -rw-r--r--···0·root·········(0)·root·········(0)··7477406·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--3.5.2.sql
51 -rw-r--r--···0·root·········(0)·root·········(0)··7848564·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--ANY--3.5.2.sql51 -rw-r--r--···0·root·········(0)·root·········(0)··7848564·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--ANY--3.5.2.sql
52 -rw-r--r--···0·root·········(0)·root·········(0)······109·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--TEMPLATED--TO--ANY.sql52 -rw-r--r--···0·root·········(0)·root·········(0)······109·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--TEMPLATED--TO--ANY.sql
53 -rw-r--r--···0·root·········(0)·root·········(0)··7928826·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged--3.5.2.sql53 -rw-r--r--···0·root·········(0)·root·········(0)··7928826·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged--3.5.2.sql
54 -rw-r--r--···0·root·········(0)·root·········(0)·······22·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged.sql54 -rw-r--r--···0·root·········(0)·root·········(0)·······22·2025-01-19·06:35:59.000000·./usr/share/postgresql/17/extension/postgis--unpackaged.sql
⊟
503 KB
./usr/share/postgresql/17/extension/address_standardizer_data_us--ANY--3.5.2.sql
    
Offset 1, 60 lines modifiedOffset 1, 8438 lines modified
 1 CREATE·TABLE·IF·NOT·EXISTS·us_lex·(
 2 »       id·serial,
 3 ····seq·integer,
 4 ····word·text,
 5 ····stdword·text,
 6 ····token·integer,·is_custom·boolean·NOT·NULL·DEFAULT·true,·CONSTRAINT·pk_us_lex·PRIMARY·KEY(id)
 7 );
  
 8 --·this·will·be·needed·for·upgrading·to·prevent·purging·of·custom·entries
 9 DELETE·FROM·us_lex·WHERE·is_custom·=·false;
  
 10 --·needed·so·entries·we·add·will·default·to·not·custom
 11 ALTER·TABLE·us_lex·ALTER·COLUMN·is_custom·SET·DEFAULT·false;
  
 12 INSERT·INTO·us_lex·(seq,·word,·stdword,·token)
 13 WITH·t(seq,word,stdword,token)·AS·(·VALUES·(1,·'#',·'#',·16),
 14 (2,·'#',·'#',·7),
 15 (1,·'&',·'AND',·13),
 16 (2,·'&',·'AND',·1),
 17 (3,·'&',·'AND',·7),
 18 (1,·'-',·'-',·9),
 19 (1,·'1·/·2',·'1/2',·25),
 20 (1,·'1·/·2·MILE',·'1/2·MI',·1),
 21 (1,·'1·/·3',·'1/3',·25),
 22 (1,·'1·/·4',·'1/4',·25),
 23 (1,·'1·MI',·'ONE·MILE',·1),
 24 (1,·'1·MILE',·'ONE·MILE',·1),
 25 (1,·'1/2',·'1/2',·25),
 26 (1,·'1/2·MILE',·'1/2·MI',·1),
 27 (1,·'1/3',·'1/3',·25),
 28 (1,·'1/4',·'1/4',·25),
 29 (1,·'10·MI',·'TEN·MILE',·1),
 30 (1,·'10·MILE',·'TEN·MILE',·1),
 31 (1,·'10MI',·'TEN·MILE',·1),
 32 (1,·'100·MILE',·'ONE·HUNDRED·MILE',·1),
 33 (1,·'11·MI',·'ELEVEN·MILE',·1),
 34 (1,·'11·MILE',·'ELEVEN·MILE',·1),
 35 (1,·'11MI',·'ELEVEN·MILE',·1),
 36 (1,·'12·MI',·'TWELVE·MILE',·1),
 37 (1,·'12·MILE',·'TWELVE·MILE',·1),
 38 (1,·'12MI',·'TWELVE·MILE',·1),
 39 (1,·'13·MI',·'THIRTEEN·MILE',·1),
 40 (1,·'13·MILE',·'THIRTEEN·MILE',·1),
 41 (1,·'13MI',·'THIRTEEN·MILE',·1),
 42 (1,·'14·MI',·'FOURTEEN·MILE',·1),
 43 (1,·'14·MILE',·'FOURTEEN·MILE',·1),
 44 (1,·'14MI',·'FOURTEEN·MILE',·1),
 45 (1,·'15·MI',·'FIFTEEN·MI',·1),
 46 (1,·'15·MILE',·'FIFTEEN·MI',·1),
 47 (1,·'15MI',·'FIFTEEN·MI',·1),
 48 (1,·'16·MI',·'SIXTEEN·MILE',·1),
 49 (1,·'16·MILE',·'SIXTEEN·MILE',·1),
 50 (1,·'16MI',·'SIXTEEN·MILE',·1),
 51 (1,·'17·MI',·'SEVENTEEN·MILE',·1),
 52 (1,·'17·MILE',·'SEVENTEEN·MILE',·1),
 53 (1,·'17MI',·'SEVENTEEN·MILE',·1),
 54 (1,·'18·MI',·'EIGHTEEEN·MILE',·1),
 55 (1,·'18·MILE',·'EIGHTEEEN·MILE',·1),
 56 (1,·'18MI',·'EIGHTEEEN·MILE',·1),
 57 (1,·'19·MI',·'NINETEEN·MILE',·1),
 58 (1,·'19·MILE',·'NINETEEN·MILE',·1),
 59 (1,·'19MI',·'NINETEEN·MILE',·1),
 60 (1,·'1ER',·'PREMIERE',·1),
 61 (1,·'1ER',·'1',·15),
 62 (1,·'1MI',·'ONE·MILE',·1),
 63 (1,·'1RE',·'PREMIERE',·1),
 64 (1,·'1RE',·'1',·15),
 65 (1,·'1ST',·'1',·1),
 66 (2,·'1ST',·'1',·15),
 67 (1,·'2·MI',·'TWO·MILE',·1),
 68 (1,·'2·MILE',·'TWO·MILE',·1),
 69 (1,·'20·MI',·'TWENTY·MILE',·1),
 70 (1,·'20·MILE',·'TWENTY·MILE',·1),
 71 (1,·'20MI',·'TWENTY·MILE',·1),
 72 (1,·'21ST',·'21',·1),
 73 (2,·'21ST',·'21',·15),
 74 (1,·'22ND',·'22',·1),
 75 (2,·'22ND',·'22',·15),
 76 (1,·'23·MI',·'TWENTY·THREE·MILE',·1),
 77 (1,·'23·MILE',·'TWENTY·THREE·MILE',·1),
 78 (1,·'23MI',·'TWENTY·THREE·MILE',·1),
 79 (1,·'23RD',·'23',·1),
 80 (2,·'23RD',·'23',·15),
 81 (1,·'2MI',·'TWO·MILE',·1),
 82 (1,·'3·/·4',·'3/4',·25),
 83 (1,·'3·/·8',·'3/8',·25),
 84 (1,·'3·MI',·'THREE·MILE',·1),
 85 (1,·'3·MILE',·'THREE·MILE',·1),
 86 (1,·'3/4',·'3/4',·25),
 87 (1,·'3/8',·'3/8',·25),
 88 (1,·'31ST',·'31',·1),
 89 (2,·'31ST',·'31',·15),
 90 (1,·'33RD',·'33',·1),
 91 (2,·'33RD',·'33',·15),
 92 (1,·'3MI',·'THREE·MILE',·1),
 93 (1,·'3RD',·'3',·1),
 94 (2,·'3RD',·'3',·15),
 95 (1,·'4·CORNERS',·'FOUR·CORNERS',·1),
 96 (1,·'4·FG',·'FOUR·FLAGS',·1),
 97 (1,·'4·FLAGS',·'FOUR·FLAGS',·1),
 98 (1,·'4·MI',·'FOUR·MILE',·1),
 99 (1,·'4·MILE',·'FOUR·MILE',·1),
 100 (1,·'4·SEASONS',·'FOUR·SEASONS',·1),
 101 (1,·'4·SN',·'FOUR·SEASONS',·1),
 102 (1,·'41ST',·'41',·1),
 103 (2,·'41ST',·'41',·15),
 104 (1,·'43RD',·'43',·1),
 105 (2,·'43RD',·'43',·15),
 106 (1,·'4MI',·'FOUR·MILE',·1),
 107 (1,·'4WD',·'FOUR·WHEEL·DRIVE·TRAIL',·2),
 108 (1,·'4WD·TRAIL',·'FOUR·WHEEL·DRIVE·TRAIL',·2),
 109 (1,·'4WD·TRL',·'FOUR·WHEEL·DRIVE·TRAIL',·2),
 110 (1,·'5·CEDARS',·'FIVE·CEDARS',·1),
 111 (1,·'5·CORNERS',·'FIVE·CORNERS',·1),
 112 (1,·'5·MI',·'FIVE·MILE',·1),
 113 (1,·'5·MILE',·'FIVE·MILE',·1),
 114 (1,·'5·POINTS',·'FIVE·POINTS',·1),
 115 (1,·'5·PT',·'FIVE·POINTS',·1),
 116 (1,·'5·TO',·'FIVE·TOWN',·1),
 117 (1,·'51ST',·'51',·1),
 118 (2,·'51ST',·'51',·15),
 119 (1,·'53RD',·'53',·1),
 120 (2,·'53RD',·'53',·15),
 121 (1,·'5MI',·'FIVE·MILE',·1),
 122 (1,·'6·FG',·'SIX·FLAGS',·1),
 123 (1,·'6·FLAGS',·'SIX·FLAGS',·1),
 124 (1,·'6·MI',·'SIX·MILE',·1),
Max diff block lines reached; 423199/515118 bytes (82.16%) of diff not shown.
Generated by diffoscope 285