Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEVaI-000000018XY-0YGa for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 07 Oct 2026 17:37:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xEVaF-00000007qQw-2N8C for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 07 Oct 2026 17:37:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEUyV-00000007ni1-1cCw for pgsql-pkg-debian@lists.postgresql.org; Wed, 07 Oct 2026 16:58:39 +0000 Received: from pv-2005e-snip6-3.eps.apple.com ([2a01:b747:3003:202::35] helo=outbound.pv.icloud.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEUyQ-00000000uz7-3aHu for pgsql-pkg-debian@postgresql.org; Wed, 07 Oct 2026 16:58:38 +0000 Received: from outbound.pv.icloud.com (unknown [127.0.0.2]) by p00-icloudmta-asmtp-us-west-1a-60-percent-3 (Postfix) with ESMTPS id 6B47D18002AA for ; Wed, 07 Oct 2026 16:58:30 +0000 (UTC) X-ICL-RepId: 01a1174d-6390-735d-8a2c-fe4a1b589664 X-ICL-Out-Info: HUtFAUMEWwJACUgATUQeDx5WFlZNRAJCTQFOHVwCXhxBDEkdXgdLVxQEElAPdwVdFlAAVglWCV0UXFZcH1BLVBQEFlwLXhNXFFgaXAlSRV0CXlhBDgpaEhhcFFxQWB5GElYNXQkZG0ReUBtfAkIPHBNWFRMdQxkPKwhKBEMHRQJeCyUTCVNWXB9fEUsIUwpQH10dHQJFDBIdUBwOUQUvcTZ6OXVVGioCQg9VB10FXx9JDTsCQAFTB0IMSAFUclgLRnkWXAteE1cUWBpcCVJFXQJeRhMZThtXTVoNQBlYBm0UVhVSBFk= Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nofixedabode.org; s=sig1; t=1791392310; x=1793984310; bh=xMBFmVx1x7nCa3iUItHoF5SiGY9TX5VZaxtnVI7d9TA=; h=From:Content-Type:Mime-Version:Subject:Message-Id:Date:To:x-icloud-hme; b=ONfkB64YAytfWq8KwCfnk6d6dsAMw7oHLbkQpzTRTez+dnKyvfD1lnJWxRPrfoi/a8qQuN8WouXonJR7tHqW5lrnRQ3VZNoBrGxc/0IOCfTsL1P5MVDKlw6kE+8U43mpxlJO5V48wCazoiMEn6XiQ63ICH4yTC3pNjNt7PT2IcvaKaIKzlD7UuwwandI/543bQHHpVzD8oWwD9U9pVRacV2rfO0NzY1m48LJoqyYJVEQBbX/f49QC5DRH8VUbDKLJPxZ5PlmCRPIN8EbScJ+Nz8OtlI7TEMcv2ZbgBkzz8WU0YQN5Xw5RhLG32OO961ZvZrshjoyCgIn2HL5NL+lFQ== mail-alias-created-date: 1619465412000 Received: from smtpclient.apple (unknown [17.156.192.29]) by p00-icloudmta-asmtp-us-west-1a-60-percent-3 (Postfix) with ESMTPSA id 6BCFF18001AA for ; Wed, 07 Oct 2026 16:58:29 +0000 (UTC) From: jcb@nofixedabode.org Content-Type: multipart/alternative; boundary="Apple-Mail=_2A69DF8F-A540-4E0F-81DF-B06014A935A6" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.700.51.1.1\)) Subject: Request: add the "postcode" extension (postal code types) to apt.postgresql.org Message-Id: <2DCFCAF8-A026-4024-94C1-68525029E396@nofixedabode.org> Date: Wed, 7 Oct 2026 17:57:57 +0100 To: pgsql-pkg-debian@postgresql.org X-Mailer: Apple Mail (2.3864.700.51.1.1) X-Proofpoint-Spam-Details-Enc: AW1haW4tMjYxMDA3MDA2NyBTYWx0ZWRfX4llMWy+lAG87 /jJkEdcJslzEUtUr+2rMT9+R57MYXjWBliDKeEPTOKm5lrxh8e8rpjZ9SR2jxlFc++neZjNRhCU gV9AQLFahhWSk8QBVkujnowYx3EWQfRXURRP+MC/pfFTanmHbEh6tPHiPHVQoTS8CQuwiCwGaoy y3ELcTDAl8dxxGzFZJtJfb1V+/GJ72HtWrJ0e56jpU9mz1uzdtPVTQaBGWtVa7RU+lIY2+oQNhx fXmHjVckz0NihSWr8PM9pg/Fcoxa+S3K+6TcSeyjbtz0mVGVs3jQnx0OTnpMhimQGBIfy7y2ZIj DdGtLoFcWNZ5brXQEvh+GYZYGfGdlx5SN2jqlTZX5R9CBjCNxLLry7HFb/0320= X-Proofpoint-GUID: lBG4xtOj4W5juoTO1m3EqBxnhorzCenW X-Authority-Info-Out: v=2.4 cv=Pf/yRyhd c=1 sm=1 tr=0 ts=6ac67a36 cx=c_apl:c_pps:t_out a=aW9mcIavGNWWFvFFKOxBSA==:117 a=aW9mcIavGNWWFvFFKOxBSA==:17 a=epTmVMiNAAAA:8 a=660iZSQnnn4A:10 a=VkNPw1HP01LnGYTKEx00:22 a=NEAV23lmAAAA:8 a=ZgHsodrNAAAA:8 a=UGcUflwQdb8hf0iJ688A:9 a=QEXdDO2ut3YA:10 a=Q2O9HSUvTb6sYgWL:21 a=_W_S_7VecoQA:10 a=g9h9Gts7lvYA:10 a=dK59-tHATs2preG_0rle:22 X-Proofpoint-ORIG-GUID: lBG4xtOj4W5juoTO1m3EqBxnhorzCenW X-JNJ: AAAAAAABODTUrfSLfg7SmyUXWlUlgP9J8OBZj2FhNFNuq9qzvxilBVqBJaaNy8t/BY0eWCjscJ/2bG+DvQAPbCdgU4gYxX2r9XpvdxsQm8elT9bG1fLy+4O5pcvVukSpVzgafGMBC7ujE0uZgjtfgQ2V+u75EBlcspcpkCdx3rKnjhxjczHVjY4elyb92UEvlAqUurbJkEIGMWYqAzscZiq0ia6RKj5W2fr9FBnJQA9p1GrQYyss2qkZrueFvZiBf1fahILk131nXg81lyw/YKc4KIf6JGaSfDIBeBy2SSJiusK9EL6ck5/bqV4h4vz3JKqbjBsLCXuyWFrIuEXOzo1xfjOHu3Fbb4U2I+UiLmSWmDpRtHmGxh6QvTgzryTAoAVUbAxO88tKHXoiwLbAv+deAvxRTeelWMdFeCisVAQ7lDRyMmrvyinDlXwH053GEX+fh7hHo7Pockrgv3oruuWCrWsDQBJitjKwjJXGjGl4V+f4PHCTeFvHxnBXqGTLh4pUggUL1SCE5HuuCyT7Y1BuZZFynoH4fYO7j+ry5ZQRvU24TLvU7yE3s5/Kq7jDNuHgtVtBV/2WnGHVhTGMxiINflTUsgM88O1JIT7nlpx9idtoExNQUdC5IBGgIoyVlFrkd7lSS9uvjxC0Qm3GXFXsEcw+k5N/my+464hhaZQOz/o9YYiKzQkBLzplLU9mdL4kgaxz9cVH2h/xhxcYwKttrhkuwZpYUSWoW9J3tVuTrIvgO9JTU1Gv6/img8qn6Ee1THPj8fErjGrVazsBYk+aoRax53bf4l3W588H3X9cM2DEWe+zUG7fl/XHK7PXhhzaZ9YluV4vhDHQ/LhxiFELqDcbqPCPSaxQqYo99BbL/YB+mbuhggupBpTXX6+DCr2MA/9U1gimhYxwV2X8m9cBToq/nNhQQ+haFL3DFDDGr1hElycyYqsAKlO+48tErIH/9etZvM8/Gu2ePSDwr/ZZJSQfOIc wM8t9r4bT+SMmToylB6hJ5PAn+23SljVoDCqifLmAZjojFF+utQhqyOUxdvUp4z0WhZt3wI/wOpxR7PesS/j1xfDdFxXAEm7YFRJwicOGJPfP5zXNwCMZDTYzhAjmITgk3mDxQQUMGbvYq3vpKDfF+aaMDITj9ZMwAPEanCkQ6zjNmZeRttr5eh49P2yKG+Y6e69wpZl1fCEqbw9QqP9nN3Jcsgvcu2Mb46qVnhY6ZwTxbZ7JPQdFPle42flkhSBSX1SwdAfb8VuRHIBTKSo3mVivndOuJ4y1QqFFXKwfqx0XIvDs7cie62iCxzWFev4b1+sr+jKCjrcIwUFxONSXIYcQ/aU0EhBjOaUF5oTaD4V6luLJz9OAl6vpsepUULtSY2BOtZDYO0iAt/R7VzHdvRoHwQw0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_2A69DF8F-A540-4E0F-81DF-B06014A935A6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Here's a draft. It's plain text, since it's going to a mailing list. Hello, I'd like to ask whether the postcode extension could be packaged for = apt.postgresql.org. It provides compact, B-tree-indexable PostgreSQL types for postal codes: = postcode for UK postcodes, and since 2.0, postal_code for 194 ISO = countries and territories. Prefix and district matching run as ordinary = index range scans. New country formats are added with SQL, with no C = needed. The postal_code segment in 2. is entirely new, and the original = patchsoft code overhauled for both functionality and correctness.=20 Repository: https://github.com/John-Cameron-Burns/pg-uk-postcodes PGXN: https://pgxn.org/dist/postcode Licence: BSD-2-Clause Current release: 2.0.1, tagged v2.0.1 Supports PostgreSQL 14 to 18; CI runs the regression suite on each = version Build system: standard PGXS Dave Green (patchsoft) wrote the original and it was orphaned on PGXN. I = have been trying for about 5 years to contact Dave Green, and David = Wheeler of PGXN could not reach him and made me a co-owner, so I = maintain it and make releases. I'm the contact for any packaging issues. For packaging, I will add a debian/ directory using dh --with=3Dpgxs, = with debian/watch for the v* tags and a machine-readable = debian/copyright Could you tell me whether it's a good fit for PGDG, and whether you'd = prefer the debian/ directory in the upstream repository or in a separate = packaging repository? I'm happy to adjust anything the packaging needs. Thank you, John Burns =E2=80=94 John Burns , formerly at JSTOR, Amazon, HP Labs, Proquest, University of = Liverpool =E2=80=A6=20 =20= --Apple-Mail=_2A69DF8F-A540-4E0F-81DF-B06014A935A6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

Here's a draft. It's plain text, = since it's going to a mailing list.


Hello,

I'd like to = ask whether the postcode extension could be = packaged for apt.postgresql.org.

It provides compact, = B-tree-indexable PostgreSQL types for postal = codes: postcode for UK postcodes, and since = 2.0, postal_code for 194 ISO countries and = territories. Prefix and district matching run as ordinary index range = scans. New country formats are added with SQL, with no C needed. =  The postal_code segment in 2. is entirely new, and the original = patchsoft code overhauled for both functionality and = correctness. 

  • Repository: = https://github.com/John-Cameron-Burns/pg-uk-postcodes
  • PGXN: &= nbsp;https://pgxn.org/dist/postcode=
  • Licence: BSD-2-Clause
  • Current release: 2.0.1, tagged = v2.0.1
  • Supports PostgreSQL 14 to 18; CI runs the regression = suite on each version
  • Build system: standard = PGXS

Dave Green (patchsoft) wrote the original and it was = orphaned on PGXN. I have been trying for about 5 years to contact Dave = Green, and David Wheeler of PGXN could not reach him and made me a = co-owner, so I maintain it and make releases. I'm the contact for any = packaging issues.

For packaging, I will add = a debian/ directory using dh = --with=3Dpgxs, with debian/watch for the = v* tags and a = machine-readable debian/copyright

Could you tell = me whether it's a good fit for PGDG, and whether you'd prefer = the debian/ directory in the upstream repository = or in a separate packaging repository? I'm happy to adjust anything the = packaging needs.

Thank you,
John Burns

=E2=80=94

= John Burns , formerly at JSTOR, Amazon, HP Labs, Proquest, University of = Liverpool =E2=80=A6 

 

= --Apple-Mail=_2A69DF8F-A540-4E0F-81DF-B06014A935A6--