Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb488c58

Browse files
committed
Allow on-the-fly capture of DDL event details
This feature lets user code inspect and take action on DDL events.Whenever a ddl_command_end event trigger is installed, DDL actionsexecuted are saved to a list which can be inspected during execution ofa function attached to ddl_command_end.The set-returning function pg_event_trigger_ddl_commands can be used tolist actions so captured; it returns data about the type of commandexecuted, as well as the affected object. This is sufficient for manyuses of this feature. For the cases where it is not, we also provide a"command" column of a new pseudo-type pg_ddl_command, which is apointer to a C structure that can be accessed by C code. The structcontains all the info necessary to completely inspect and evenreconstruct the executed command.There is no actual deparse code here; that's expected to come later.What we have is enough infrastructure that the deparsing can be done inan external extension. The intention is that we will add some deparsingcode in a later release, as an in-core extension.A new test module is included. It's probably insufficient as is, but itshould be sufficient as a starting point for a more complete andfuture-proof approach.Authors: Álvaro Herrera, with some help from Andres Freund, Ian Barwick,Abhijit Menon-Sen.Reviews by Andres Freund, Robert Haas, Amit Kapila, Michael Paquier,Craig Ringer, David Steele.Additional input from Chris Browne, Dimitri Fontaine, Stephen Frost,Petr Jelínek, Tom Lane, Jim Nasby, Steven Singer, Pavel Stěhule.Based on original work by Dimitri Fontaine, though I didn't use hiscode.Discussion:https://www.postgresql.org/message-id/m2txrsdzxa.fsf@2ndQuadrant.frhttps://www.postgresql.org/message-id/20131108153322.GU5809@eldon.alvh.no-ip.orghttps://www.postgresql.org/message-id/20150215044814.GL3391@alvh.no-ip.org
1 parentfa26424 commitb488c58

File tree

72 files changed

+2667
-155
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

72 files changed

+2667
-155
lines changed

‎doc/src/sgml/event-trigger.sgml

Lines changed: 9 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,8 @@
2929
occurs in the database in which it is defined. Currently, the only
3030
supported events are
3131
<literal>ddl_command_start</>,
32-
<literal>ddl_command_end</>
32+
<literal>ddl_command_end</>,
33+
<literal>table_rewrite</>
3334
and <literal>sql_drop</>.
3435
Support for additional events may be added in future releases.
3536
</para>
@@ -52,7 +53,13 @@
5253

5354
<para>
5455
The <literal>ddl_command_end</> event occurs just after the execution of
55-
this same set of commands.
56+
this same set of commands. To obtain more details on the <acronym>DDL</>
57+
operations that took place, use the set-returning function
58+
<literal>pg_event_trigger_ddl_commands()</> from the
59+
<literal>ddl_command_end</> event trigger code (see
60+
<xref linkend="functions-event-triggers">). Note that the trigger fires
61+
after the actions have taken place (but before the transaction commits),
62+
and thus the system catalogs can be read as already changed.
5663
</para>
5764

5865
<para>

‎doc/src/sgml/func.sgml

Lines changed: 92 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -18066,8 +18066,99 @@ FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
1806618066
see <xref linkend="event-triggers">.
1806718067
</para>
1806818068

18069+
<sect2 id="pg-event-trigger-ddl-command-end-functions">
18070+
<title>Capturing Changes at Command End</title>
18071+
18072+
<indexterm>
18073+
<primary>pg_event_trigger_ddl_commands</primary>
18074+
</indexterm>
18075+
18076+
<para>
18077+
<function>pg_event_trigger_ddl_commands</> returns a list of
18078+
<acronym>DDL</acronym> commands executed by each user action,
18079+
when invoked in a function attached to a
18080+
<literal>ddl_command_end</> event trigger. If called in any other
18081+
context, an error is raised.
18082+
<function>pg_event_trigger_ddl_commands</> returns one row for each
18083+
base command executed; some commands that are a single SQL sentence
18084+
may return more than one row. This function returns the following
18085+
columns:
18086+
18087+
<informaltable>
18088+
<tgroup cols="3">
18089+
<thead>
18090+
<row>
18091+
<entry>Name</entry>
18092+
<entry>Type</entry>
18093+
<entry>Description</entry>
18094+
</row>
18095+
</thead>
18096+
18097+
<tbody>
18098+
<row>
18099+
<entry><literal>classid</literal></entry>
18100+
<entry><type>Oid</type></entry>
18101+
<entry>OID of catalog the object belongs in</entry>
18102+
</row>
18103+
<row>
18104+
<entry><literal>objid</literal></entry>
18105+
<entry><type>Oid</type></entry>
18106+
<entry>OID of the object in the catalog</entry>
18107+
</row>
18108+
<row>
18109+
<entry><literal>objsubid</literal></entry>
18110+
<entry><type>integer</type></entry>
18111+
<entry>Object sub-id (e.g. attribute number for columns)</entry>
18112+
</row>
18113+
<row>
18114+
<entry><literal>command_tag</literal></entry>
18115+
<entry><type>text</type></entry>
18116+
<entry>command tag</entry>
18117+
</row>
18118+
<row>
18119+
<entry><literal>object_type</literal></entry>
18120+
<entry><type>text</type></entry>
18121+
<entry>Type of the object</entry>
18122+
</row>
18123+
<row>
18124+
<entry><literal>schema_name</literal></entry>
18125+
<entry><type>text</type></entry>
18126+
<entry>
18127+
Name of the schema the object belongs in, if any; otherwise <literal>NULL</>.
18128+
No quoting is applied.
18129+
</entry>
18130+
</row>
18131+
<row>
18132+
<entry><literal>object_identity</literal></entry>
18133+
<entry><type>text</type></entry>
18134+
<entry>
18135+
Text rendering of the object identity, schema-qualified. Each and every
18136+
identifier present in the identity is quoted if necessary.
18137+
</entry>
18138+
</row>
18139+
<row>
18140+
<entry><literal>in_extension</literal></entry>
18141+
<entry><type>bool</type></entry>
18142+
<entry>whether the command is part of an extension script</entry>
18143+
</row>
18144+
<row>
18145+
<entry><literal>command</literal></entry>
18146+
<entry><type>pg_ddl_command</type></entry>
18147+
<entry>
18148+
A complete representation of the command, in internal format.
18149+
This cannot be output directly, but it can be passed to other
18150+
functions to obtain different pieces of information about the
18151+
command.
18152+
</entry>
18153+
</row>
18154+
</tbody>
18155+
</tgroup>
18156+
</informaltable>
18157+
</para>
18158+
</sect2>
18159+
1806918160
<sect2 id="pg-event-trigger-sql-drop-functions">
18070-
<title>Processingobjects dropped by a DDLcommand.</title>
18161+
<title>ProcessingObjects Dropped by a DDLCommand</title>
1807118162

1807218163
<indexterm>
1807318164
<primary>pg_event_trigger_dropped_objects</primary>

‎src/backend/catalog/aclchk.c

Lines changed: 11 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -48,6 +48,7 @@
4848
#include"catalog/pg_ts_config.h"
4949
#include"catalog/pg_ts_dict.h"
5050
#include"commands/dbcommands.h"
51+
#include"commands/event_trigger.h"
5152
#include"commands/proclang.h"
5253
#include"commands/tablespace.h"
5354
#include"foreign/foreign.h"
@@ -56,6 +57,7 @@
5657
#include"parser/parse_func.h"
5758
#include"parser/parse_type.h"
5859
#include"utils/acl.h"
60+
#include"utils/aclchk_internal.h"
5961
#include"utils/builtins.h"
6062
#include"utils/fmgroids.h"
6163
#include"utils/lsyscache.h"
@@ -64,32 +66,6 @@
6466
#include"utils/tqual.h"
6567

6668

67-
/*
68-
* The information about one Grant/Revoke statement, in internal format: object
69-
* and grantees names have been turned into Oids, the privilege list is an
70-
* AclMode bitmask. If 'privileges' is ACL_NO_RIGHTS (the 0 value) and
71-
* all_privs is true, 'privileges' will be internally set to the right kind of
72-
* ACL_ALL_RIGHTS_*, depending on the object type (NB - this will modify the
73-
* InternalGrant struct!)
74-
*
75-
* Note: 'all_privs' and 'privileges' represent object-level privileges only.
76-
* There might also be column-level privilege specifications, which are
77-
* represented in col_privs (this is a list of untransformed AccessPriv nodes).
78-
* Column privileges are only valid for objtype ACL_OBJECT_RELATION.
79-
*/
80-
typedefstruct
81-
{
82-
boolis_grant;
83-
GrantObjectTypeobjtype;
84-
List*objects;
85-
boolall_privs;
86-
AclModeprivileges;
87-
List*col_privs;
88-
List*grantees;
89-
boolgrant_option;
90-
DropBehaviorbehavior;
91-
}InternalGrant;
92-
9369
/*
9470
* Internal format used by ALTER DEFAULT PRIVILEGES.
9571
*/
@@ -605,6 +581,15 @@ ExecGrantStmt_oids(InternalGrant *istmt)
605581
elog(ERROR,"unrecognized GrantStmt.objtype: %d",
606582
(int)istmt->objtype);
607583
}
584+
585+
/*
586+
* Pass the info to event triggers about the just-executed GRANT. Note
587+
* that we prefer to do it after actually executing it, because that gives
588+
* the functions a chance to adjust the istmt with privileges actually
589+
* granted.
590+
*/
591+
if (EventTriggerSupportsGrantObjectType(istmt->objtype))
592+
EventTriggerCollectGrant(istmt);
608593
}
609594

610595
/*

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp