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 1xGGqX-00000002CJQ-21mb for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 14:17:45 +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 1xGGqV-00000008xFg-34un for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 14:17:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGGqV-00000008xFX-1gSV for pgsql-general@lists.postgresql.org; Mon, 12 Oct 2026 14:17:43 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGGqT-00000001e2O-1kyA for pgsql-general@postgresql.org; Mon, 12 Oct 2026 14:17:42 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 1EF0B1400105 for ; Mon, 12 Oct 2026 10:17:40 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Mon, 12 Oct 2026 10:17:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1791814660; x=1791901060; bh=bKcnl0vLOctMSYGcnH/eUvS9iKTkZGZLXo9fmoeFXVA=; b= jVCsgf2hyeWkCDgD9AURmjWwYe+2YzBJNGbJ3l4ngJEXX2ayv2217ua5rWz5jbgh aV6ydmnbb89t543rLV1IzFsUbJ+w+6UhSir1it1erzvpD3hn7kkZJcUBEbBrVtri h/eAKySv8xIcU4AC0Tsk2AQatKikmHVlVfS6AlA2oOTrTCvUaYLPDCRe1o/rewYQ Q8oZ9qUGhqnd9PhLm+TZRtP8qJ1PcFFSREG5aU+dtlGgmrjMrUGKYxPgJXvE7T5n 4G/wjQQdN7yAYkUPxQmLofQxG7ZhD1KQ3I8ex0LH2QPmRTUrSe3btEWw0+0rkWZ0 FvkqY4GzsaYRw0ftQH566A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1791814660; x=1791901060; bh=b Kcnl0vLOctMSYGcnH/eUvS9iKTkZGZLXo9fmoeFXVA=; b=IyRS+/Vx+oBIdmp2w UihrmC8G8hGTvugLmeMKztbx8nuE+c2vwAkLbH7A2Xwy9uV6C9i1PnCqrrSMTuyO lHmt+N9aKbSUS91k4/Z45NaAOyUA2UTMmQsOu1VzGpXEKdCKGp97TTPyQ40lgNA4 lu/+R+UxswHUyfi3mx+17SPprkVq8o52eUHraIB+2bkOJ5vQAM4yU61ejQoEIOjf fWDZ0AN5QtW6mRHv6WCMQRFPFyFTmR9FjZQUOpI3sdzoT4hveAFlVJLCElwV/2DQ pe51Jzr68F3QbXNPZBCxa0lBe498EDnlUZ8+GMU8pN2TcNxAtn/z12o2BvjOr6k8 vt2Bg== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791814660; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:LCF6dKShHrrGMUQs8NnuRjnZF1mfl7t2nPS8qyECyF1qvXm bH7btR4W4iPXl91AoqrX8/RCBOewWi7Zly/qW6vYHzrsmGLZly4iORvFC4ogiki3 Ko67q3+kpZCJzlrI35jwcoPUcOD4HYiHhRY2xbR1Nzcw4wNuOiT6dEmn/MYVgBSy MyXFPglEM9yb9yXCutsXHHfXTd9aTM4ChXdbn+IuY4HiODYfKsMtB+rlwOGqt6mp HFfG4JCa9WKSUjXQnP40ZAVCb4ZJiy5zRJ7RbhxUBJfDY8urqM6ez4A9YP2TUkcj eWpND7w71PV6T5SbxrbeCWJWF40Ht+nLWX6UgVA==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=mi-m=1; hc=13; hn=content-language,content-transfer-encoding,content-type,date, feedback-id,from,in-reply-to,message-id,mime-version,references, subject,to,user-agent; Message-Instance: m=1; h=sha256:H3RyEkFnaBQo8GiGIz/lJrTjk+Flvz07Otf875uXN/c=:YdZxKqJ9Qh28PfuT7EhCV9xk+S6HpmgZCeU/txJx/Ew=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFZ0NbHoZyiBwTckGye7o7qAV7wpFRS+ZtbGaeTe/36QUGIZu+82/PW+MeUNou8Ph KpH9SQvLTUUtoXQd1/Xdx0aG6ZbCf1H77pjdya29QsRAfTZXUOalGXsT4tTktIFl2q08qa lRpkUgepNmHB6+3QtZ51P6P+RxoHut/to+Lr1DVjKTDeBkBLM5hGymOW8kGUIg4fxIiRhu uuTayhc6VIgDRtAFUGi/9fm8JEcBoZ5btwf8YiaAHY+JFwV7b5nCCLFaXUr6Dfq4SVXH5Z 5XV56NsCmY1mfoss9jEXKm8BWb9CpVP7Q3BDXJR0Ohv0M4ycaCdmvQQgjZt4iTewG/ygeU Ajy+HES86dMOySo9NDfn/v3maWbSg9A174g3C5w0zpORg1DMfk3NIVlvV4BGk1Y/3uD7TZ jAbtEairsYUbgUeZS0wsLez7TTv3zLr+0DbeuhBg5Uv8KXh0ZBB6dlwlytephzsqpldmEY 5VYqkLdddlgulnJq/z5Dm6mjKrGe6kftcOO7potzd7EfQ5QvPIwXv7MTLiSo33ptZoQohN pt64YvKx65otmEUYqtGS1qrDC0KkCiJH8aCyFA5TiA5mU9TRDpRSWRtY3LoylNxOWDNLPc 5pKghZM/vdun4Enj3hRgd2aL8OpkpvesWySD335pdm81uq1On+FJrBR4p6Kw X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 12 Oct 2026 10:17:38 -0400 (EDT) Message-ID: <3da46e1d-2c3e-40e4-b464-05fce7949730@aklaver.com> Date: Mon, 12 Oct 2026 07:17:38 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_event_trigger_ddl_commands after GRANT is quite empty To: =?UTF-8?Q?F=C3=A4rber=2C_Franz-Josef_=28StMUK=29?= , "pgsql-general@postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/12/26 1:47 AM, Färber, Franz-Josef (StMUK) wrote: > Dear Postgres Community, > > pg_event_trigger_ddl_commands after GRANT is quite empty. > > If I execute: GRANT SELECT ON TABLE t TO r; > > . and in a trigger function I have: > > SELECT classid, objid, objsubid, command_tag, object_type, schema_name, object_identity > FROM pg_event_trigger_ddl_commands(); > > This gives me: > > null, null, null, GRANT, TABLE, null, null > Postgres version? What is the complete trigger and trigger function definition? > > How to find out the table involved and the privileges? > > > Regards, > Franz-Josef Färber > > -- Adrian Klaver adrian.klaver@aklaver.com