MIME-Version: 1.0
References: 
 <CAKNkYnxUPCJk-3Xe0A3rmCC8B8V8kqVJbYMVN6ySGpjs_qd7dQ@mail.gmail.com>
 <202603181633.32bikq5m7kh6@alvherre.pgsql>
In-Reply-To: <202603181633.32bikq5m7kh6@alvherre.pgsql>
Reply-To: zaartur@gmail.com
From: Artur Zakirov <zaartur@gmail.com>
Date: Wed, 18 Mar 2026 17:55:25 +0100
Message-ID: 
 <CAKNkYnzAKjibTv4HVPxY4FgPp7W0cX2zToo+DjUF93CLMMq6Sg@mail.gmail.com>
Subject: Re: Order of InvokeObjectPostAlterHook within ATExecSetNotNull
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000002d6ffa064d4f523d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKNkYnzAKjibTv4HVPxY4FgPp7W0cX2zToo%2BDjUF93CLMMq6Sg%40mail.gmail.com>
Precedence: bulk

--0000000000002d6ffa064d4f523d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, 18 Mar 2026 at 17:34, =C3=81lvaro Herrera <alvherre@kurilemu.de> wr=
ote:
> >
> > Is this an intended behavior or rather a bug?
>
> This was not intentional.  Want to submit a patch?
>
> --
> =C3=81lvaro Herrera               48=C2=B001'N 7=C2=B057'E  =E2=80=94  ht=
tps://www.EnterpriseDB.com/

Thank you for the quick response. Sure, I attached the patch for the
main branch and for REL_18_STABLE just in case, although the main
patch also should apply to REL_18_STABLE.
I think we might need to backpatch it to PG 18 too where the change
was introduced.

--=20
Kind regards,
Artur

--0000000000002d6ffa064d4f523d
Content-Type: application/octet-stream;
	name="object_access_hook_attnotnull_order_18.patch"
Content-Disposition: attachment;
	filename="object_access_hook_attnotnull_order_18.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mmwa5cfv0>
X-Attachment-Id: f_mmwa5cfv0

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jIGIvc3JjL2JhY2tl
bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKaW5kZXggZGQyYjRhNTEwNzYuLjliMGFhZDk1YTBhIDEw
MDY0NAotLS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYworKysgYi9zcmMvYmFj
a2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYwpAQCAtODA1MCwxMiArODA1MCwxMiBAQCBBVEV4ZWNT
ZXROb3ROdWxsKExpc3QgKip3cXVldWUsIFJlbGF0aW9uIHJlbCwgY2hhciAqY29uTmFtZSwgY2hh
ciAqY29sTmFtZSwKIAljY29uID0gbGluaXRpYWwoY29va2VkKTsKIAlPYmplY3RBZGRyZXNzU2V0
KGFkZHJlc3MsIENvbnN0cmFpbnRSZWxhdGlvbklkLCBjY29uLT5jb25vaWQpOwogCi0JSW52b2tl
T2JqZWN0UG9zdEFsdGVySG9vayhSZWxhdGlvblJlbGF0aW9uSWQsCi0JCQkJCQkJICBSZWxhdGlv
bkdldFJlbGlkKHJlbCksIGF0dG51bSk7Ci0KIAkvKiBNYXJrIHBnX2F0dHJpYnV0ZS5hdHRub3Ru
dWxsIGZvciB0aGUgY29sdW1uIGFuZCBxdWV1ZSB2YWxpZGF0aW9uICovCiAJc2V0X2F0dG5vdG51
bGwod3F1ZXVlLCByZWwsIGF0dG51bSwgdHJ1ZSwgdHJ1ZSk7CiAKKwlJbnZva2VPYmplY3RQb3N0
QWx0ZXJIb29rKFJlbGF0aW9uUmVsYXRpb25JZCwKKwkJCQkJCQkgIFJlbGF0aW9uR2V0UmVsaWQo
cmVsKSwgYXR0bnVtKTsKKwogCS8qCiAJICogUmVjdXJzZSB0byBwcm9wYWdhdGUgdGhlIGNvbnN0
cmFpbnQgdG8gY2hpbGRyZW4gdGhhdCBkb24ndCBoYXZlIG9uZS4KIAkgKi8K
--0000000000002d6ffa064d4f523d
Content-Type: application/octet-stream;
	name="object_access_hook_attnotnull_order.patch"
Content-Disposition: attachment;
	filename="object_access_hook_attnotnull_order.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mmwa5cgi1>
X-Attachment-Id: f_mmwa5cgi1

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jIGIvc3JjL2JhY2tl
bmQvY29tbWFuZHMvdGFibGVjbWRzLmMKaW5kZXggNjdlNDJlNWRmMjkuLmE1YWMzODU3OGY2IDEw
MDY0NAotLS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYworKysgYi9zcmMvYmFj
a2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYwpAQCAtODEzNywxMiArODEzNywxMiBAQCBBVEV4ZWNT
ZXROb3ROdWxsKExpc3QgKip3cXVldWUsIFJlbGF0aW9uIHJlbCwgY2hhciAqY29uTmFtZSwgY2hh
ciAqY29sTmFtZSwKIAljY29uID0gbGluaXRpYWwoY29va2VkKTsKIAlPYmplY3RBZGRyZXNzU2V0
KGFkZHJlc3MsIENvbnN0cmFpbnRSZWxhdGlvbklkLCBjY29uLT5jb25vaWQpOwogCi0JSW52b2tl
T2JqZWN0UG9zdEFsdGVySG9vayhSZWxhdGlvblJlbGF0aW9uSWQsCi0JCQkJCQkJICBSZWxhdGlv
bkdldFJlbGlkKHJlbCksIGF0dG51bSk7Ci0KIAkvKiBNYXJrIHBnX2F0dHJpYnV0ZS5hdHRub3Ru
dWxsIGZvciB0aGUgY29sdW1uIGFuZCBxdWV1ZSB2YWxpZGF0aW9uICovCiAJc2V0X2F0dG5vdG51
bGwod3F1ZXVlLCByZWwsIGF0dG51bSwgdHJ1ZSwgdHJ1ZSk7CiAKKwlJbnZva2VPYmplY3RQb3N0
QWx0ZXJIb29rKFJlbGF0aW9uUmVsYXRpb25JZCwKKwkJCQkJCQkgIFJlbGF0aW9uR2V0UmVsaWQo
cmVsKSwgYXR0bnVtKTsKKwogCS8qCiAJICogUmVjdXJzZSB0byBwcm9wYWdhdGUgdGhlIGNvbnN0
cmFpbnQgdG8gY2hpbGRyZW4gdGhhdCBkb24ndCBoYXZlIG9uZS4KIAkgKi8K
--0000000000002d6ffa064d4f523d--