CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions

Edit
ID 5941
Title CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
CI (CFBot) Summary
Stats (from CFBot) Patch version: v33, Patch count: 3, First patch: +66−14, All patches: +3202−210
Tags SQL Commands
Created 2025-08-01 07:44:41
Last modified 2026-09-02 02:40:31 (2 weeks ago)
Latest email 2026-09-16 07:47:52 (4 days ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
Target version 19
Authors Jian He (stayreal)
Reviewers Corey Huinker (coreyh), Henson Choi (assam258.gmail.com) Become reviewer
Committer
Links
Emails
CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
First at 2022-12-19 22:56:37 by Corey Huinker <corey.huinker at gmail.com>
Latest at 2026-09-16 07:47:52 by jian he <jian.universality at gmail.com>
Latest attachment (v33-0002-introduce-pg_proc.proerrorsafe.patch) at 2026-09-16 07:47:52 from jian he <jian.universality at gmail.com>
    Attachment (v33-0002-introduce-pg_proc.proerrorsafe.patch) at 2026-09-16 07:47:52 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v32-0001-error-safe-for-casting-text-to-other-types-per-pg_cast.patch) at 2026-07-15 09:06:32 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v31-0002-introduce-pg_proc.proerrorsafe.patch) at 2026-07-07 07:49:48 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v30-0001-error-safe-for-casting-text-to-other-types-per-pg_cast.patch) at 2026-06-23 02:50:25 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v29-0001-error-safe-for-casting-text-to-other-types-per-pg_cast.patch) at 2026-04-03 03:14:57 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (bma014-cast-error-default--draft-01.pdf) at 2026-04-02 16:03:28 from Vik Fearing <vik at postgresfriends.org> (Patch: No)
    Attachment (v28-0002-CAST-expr-AS-newtype-DEFAULT-expr-ON-CONVERSION-ERROR.patch) at 2026-03-31 14:47:37 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v27-0001-error-safe-for-casting-text-to-other-types-per-pg_cast.patch) at 2026-03-31 07:23:40 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v26-0002-CAST-expr-AS-newtype-DEFAULT-expr-ON-CONVERSION-ERROR.patch) at 2026-03-30 14:47:32 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v25-0008-error-safe-for-casting-money-data-type.patch) at 2026-03-28 00:37:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v24-0008-error-safe-for-casting-money-data-type.patch) at 2026-03-25 13:13:49 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v23-0019-introduce-float8-safe-function.patch) at 2026-03-21 08:16:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v22-0020-refactor-point_dt.patch) at 2026-03-20 08:15:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v21-0003-error-safe-for-casting-character-to-other-types-per-pg_cast.patch) at 2026-03-17 05:51:15 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v20-0020-refactor-point_dt.patch) at 2026-03-13 06:19:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v19-0009-error-safe-for-casting-bigint-to-other-types-per-pg_cast.patch) at 2026-03-13 01:00:13 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v18-0022-CAST-expr-AS-newtype-DEFAULT-expr-ON-CONVERSION-ERROR.patch) at 2026-01-14 06:37:26 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v17-0022-CAST-expr-AS-newtype-DEFAULT-ON-ERROR.patch) at 2026-01-05 06:01:02 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v16-0023-error-safe-for-user-defined-CREATE-CAST.patch) at 2025-12-15 04:37:43 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v15-0022-error-safe-for-user-defined-CREATE-CAST.patch) at 2025-12-10 08:57:09 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v14-0016-error-safe-for-casting-timestamp-to-other-types-per-pg_cast.patch) at 2025-12-08 14:58:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v13-0018-error-safe-for-casting-geometry-data-type.patch) at 2025-12-02 07:52:57 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0019-invent-some-error-safe-functions.patch) at 2025-11-25 12:27:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0018-error-safe-for-casting-geometry-data-type.patch) at 2025-11-25 02:59:42 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v10-0016-error-safe-for-casting-timestamp-to-other-types-per-pg_cast.patch) at 2025-11-11 03:06:11 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v9-0017-error-safe-for-casting-jsonb-to-other-types-per-pg_cast.patch) at 2025-11-04 06:02:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0017-error-safe-for-casting-jsonb-to-other-types-per-pg_cast.patch) at 2025-10-14 02:00:26 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v7-0019-invent-some-error-safe-functions.patch) at 2025-10-10 12:23:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0016-error-safe-for-casting-character-varying-to-other-types-p.patch) at 2025-08-11 06:18:44 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0002-make-ArrayCoerceExpr-error-safe.patch) at 2025-08-04 01:46:45 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0002-make-ArrayCoerceExpr-error-safe.patch) at 2025-08-01 05:55:44 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-make-ArrayCoerceExpr-error-safe.patch) at 2025-07-24 01:22:19 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-make-ArrayCoerceExpr-error-safe.patch) at 2025-07-22 01:59:19 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-add-OidInputFunctionCall.patch) at 2022-12-19 22:56:37 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
History
When Who What
2026-09-16 08:01:43 CFbot Patch does not need rebase anymore
2026-09-02 02:40:31 Jian He (stayreal) Moved from CF PG20-2 to CF PG20-3
2026-08-26 18:42:29 CFbot Patch needs rebase
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-15 09:35:37 CFbot Patch does not need rebase anymore
2026-07-10 00:22:31 CFbot Patch needs rebase
2026-06-29 04:29:06 Henson Choi (assam258.gmail.com) Added assam258.gmail.com as reviewer
2026-06-23 03:04:35 CFbot Patch does not need rebase anymore
2026-04-10 08:55:15 Peter Eisentraut (petere) Removed petere from committers
2026-04-10 00:00:02 CFbot Moved from CF PG19-Final to CF PG20-1
2026-04-07 05:49:29 CFbot Patch needs rebase
2026-03-27 15:33:09 Peter Eisentraut (petere) New status: Needs review
2026-03-25 13:41:37 CFbot Patch does not need rebase anymore
2026-03-25 01:12:43 CFbot Patch needs rebase
2026-03-24 13:18:19 Peter Eisentraut (petere) New status: Waiting on Author
2026-03-16 03:49:26 Corey Huinker (coreyh) New status: Ready for Committer
2026-03-16 03:49:15 Corey Huinker (coreyh) Added coreyh as reviewer
2026-03-13 01:39:43 CFbot Patch does not need rebase anymore
2026-03-13 00:22:43 CFbot Patch needs rebase
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-14 07:15:44 CFbot Patch does not need rebase anymore
2026-01-05 17:46:39 CFbot Patch needs rebase
2025-12-28 10:28:33 CFbot Patch does not need rebase anymore
2025-12-26 16:22:32 CFbot Patch needs rebase
2025-12-15 05:07:40 CFbot Patch does not need rebase anymore
2025-12-10 04:48:31 CFbot Patch needs rebase
2025-12-03 08:55:42 Jian He (stayreal) Moved from CF PG19-3 to CF PG19-4
2025-12-03 02:18:34 CFbot Patch does not need rebase anymore
2025-11-27 15:41:27 CFbot Patch needs rebase
2025-11-25 20:27:16 Peter Eisentraut (petere) Added petere as committer
2025-11-04 06:44:38 CFbot Patch does not need rebase anymore
2025-10-24 02:03:35 CFbot Patch needs rebase
2025-10-10 12:33:37 CFbot Patch does not need rebase anymore
2025-10-09 16:10:04 Jian He (stayreal) Moved from CF PG19-2 to CF PG19-3
2025-09-06 15:14:28 CFbot Patch needs rebase
2025-08-01 07:44:42 Jian He (stayreal) Attached mail thread CADkLM=fv1JfY4Ufa-jcwwNbjQixNViskQ8jZu3Tz_p656i_4hQ@mail.gmail.com
2025-08-01 07:44:42 Jian He (stayreal) Created patch record
Edit