bug: virtual generated column can be partition key

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +86−40, All patches: +86−40

Topic

Bug Fixes

Tags

Backport Bugfix

Created

2025-08-25 02:54:48

Last modified

2025-10-19 11:35:19 (4 hours ago)

Latest email

2025-08-29 13:54:20 (1 month ago)

Status

PG19-3 (2025-11-01 – 2025-11-30): Needs review

PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF

Target version

Authors

Ashutosh Bapat (ashutoshbapat)

Reviewers

Peter Eisentraut (petere)Become reviewer

Committer

Peter Eisentraut (petere)

Links

Emails

bug: virtual generated column can be partition key: First at 2025-04-21 02:30:01 by jian he <jian.universality at gmail.com>
Latest at 2025-08-29 13:54:20 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (0001-Tighten-check-for-generated-column-in-parti-20250422.patch) at 2025-04-22 08:47:28 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
    Attachment (0001-Tighten-check-for-generated-column-in-parti-20250422.patch) at 2025-04-22 08:47:28 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (partition_expr_generated_minor_errormessage.diff) at 2025-04-22 08:44:50 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Tighten-check-for-generated-column-in-parti-20250421.patch) at 2025-04-22 03:45:43 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-virtual-generated-column-can-be-partition-key.patch) at 2025-04-21 09:11:51 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-virtual-generated-column-can-be-partition-key.patch) at 2025-04-21 02:30:01 from jian he <jian.universality at gmail.com> (Patch: Yes)

History

When	Who	What
2025-10-19 11:35:19	Álvaro Herrera (alvherre)	Moved from CF PG19-2 to CF PG19-3
2025-08-27 15:43:45	Peter Eisentraut (petere)	Added petere as committer
2025-08-27 15:43:42	Peter Eisentraut (petere)	Added petere as reviewer
2025-08-25 02:54:48	Jian He (stayreal)	Attached mail thread CACJufxF=WDGthXSAQr9thYUsfx_1_t9E6N8tE3B8EqXcVoVfQw@mail.gmail.com
2025-08-25 02:54:48	Jian He (stayreal)	Created patch record