Postgresql - plpgsql - Event Trigger 讲解_postgresql全局触发器

Command Tag

ddl_command_start

ddl_command_end

sql_drop

table_rewrite

Notes

ALTER AGGREGATE

X

X

-

-

ALTER COLLATION

X

X

-

-

ALTER CONVERSION

X

X

-

-

ALTER DOMAIN

X

X

-

-

ALTER EXTENSION

X

X

-

-

ALTER FOREIGN DATA WRAPPER

X

X

-

-

ALTER FOREIGN TABLE

X

X

X

-

ALTER FUNCTION

X

X

-

-

ALTER LANGUAGE

X

X

-

-

ALTER OPERATOR

X

X

-

-

ALTER OPERATOR CLASS

X

X

-

-

ALTER OPERATOR FAMILY

X

X

-

-

ALTER POLICY

X

X

-

-

ALTER SCHEMA

X

X

-

-

ALTER SEQUENCE

X

X

-

-

ALTER SERVER

X

X

-

-

ALTER TABLE

X

X

X

X

ALTER TEXT SEARCH CONFIGURATION

X

X

-

-

ALTER TEXT SEARCH DICTIONARY

X

X

-

-

ALTER TEXT SEARCH PARSER

X

X

-

-

ALTER TEXT SEARCH TEMPLATE

X

X

-

-

ALTER TRIGGER

X

X

-

-

ALTER TYPE

X

X

-

X

ALTER USER MAPPING

X

X

-

-

ALTER VIEW

X

X

-

-

CREATE AGGREGATE

X

X

-

-

COMMENT

X

X

-

-

Only for local objects

CREATE CAST

X

X

-

-

CREATE COLLATION

X

X

-

-

CREATE CONVERSION

X

X

-

-

CREATE DOMAIN

X

X

-

-

CREATE EXTENSION

X

X

-

-

CREATE FOREIGN DATA WRAPPER

X

X

-

-

CREATE FOREIGN TABLE

X

X

-

-

CREATE FUNCTION

X

X

-

-

CREATE INDEX

X

X

-

-

CREATE LANGUAGE

X

X

-

-

CREATE OPERATOR

X

X

-

-

CREATE OPERATOR CLASS

X

X

-

-

CREATE OPERATOR FAMILY

X

X

-

-

CREATE POLICY

X

X

-

-

CREATE RULE

X

X

-

-

CREATE SCHEMA

X

X

-

-

CREATE SEQUENCE

X

X

-

-

CREATE SERVER

X

X

-

-

CREATE STATISTICS

X

X

-

-

CREATE TABLE

X

X

-

-

CREATE TABLE AS

X

X

-

-

CREATE TEXT SEARCH CONFIGURATION

X

X

-

-

CREATE TEXT SEARCH DICTIONARY

X

X

-

-

CREATE TEXT SEARCH PARSER

X

X

-

-

CREATE TEXT SEARCH TEMPLATE

X

X

-

-

CREATE TRIGGER

X

X

-

-

CREATE TYPE

X

X

-

-

CREATE USER MAPPING

X

X

-

-

CREATE VIEW

X

X

-

-

DROP AGGREGATE

X

X

X

-

DROP CAST

X

X

X

-

DROP COLLATION

X

X

X

-

DROP CONVERSION

X

X

X

-

DROP DOMAIN

X

X

X

-

DROP EXTENSION

X

X

X

-

DROP FOREIGN DATA WRAPPER

X

X

X

-

DROP FOREIGN TABLE

X

X

X

-

DROP FUNCTION

X

X

X

-

DROP INDEX

X

X

X

-

DROP LANGUAGE

X

X

X

-

DROP OPERATOR

X

X

X

-

DROP OPERATOR CLASS

X

X

X

-

DROP OPERATOR FAMILY

X

X

X

-

DROP OWNED

X

X

X

-

DROP POLICY

X

X

X

-

DROP RULE

X

X

X

-

DROP SCHEMA

X

X

X

-

DROP SEQUENCE

X

X

X

-

DROP SERVER

X

X

X

-

DROP STATISTICS

X

X

X

-

DROP TABLE

X

X

X

-

DROP TEXT SEARCH CONFIGURATION

X

X

X

-

DROP TEXT SEARCH DICTIONARY

X

X

X

-

DROP TEXT SEARCH PARSER

X

X

X

-

DROP TEXT SEARCH TEMPLATE

X

X

X

-

DROP TRIGGER

X

X

X

-

DROP TYPE

X

X

X

-

DROP USER MAPPING

X

X

X

-

DROP VIEW

X

X

X

-

GRANT

X

X

-

-

Only for local objects

IMPORT FOREIGN SCHEMA

X

X

-

-

REVOKE

X

X

-

-

Only for local objects

SECURITY LABEL

X

X

-

-

Only for local objects

SELECT INTO

X

X

-

-

Name

Type

Description

classid

oid

OID of catalog the object belongs in

objid

oid

OID of the object itself

objsubid

integer

Sub-object ID (e.g. attribute number for a column)

command_tag

text

Command tag

object_type

text

Type of the object

schema_name

text

Name of the schema the object belongs in, if any; otherwise NULL. No quoting is applied.

object_identity

text

Text rendering of the object identity, schema-qualified. Each identifier included in the identity is quoted if necessary.

in_extension

bool

True if the command is part of an extension script

command

pg_ddl_command

A complete representation of the command, in internal format. This cannot be output directly, but it can be passed to other functions to obtain different pieces of information about the command.

Name

Type

Description

classid

oid

OID of catalog the object belonged in

objid

oid

OID of the object itself

objsubid

integer

Sub-object ID (e.g. attribute number for a column)

original

bool

True if this was one of the root object(s) of the deletion

normal

bool

True if there was a normal dependency relationship in the dependency graph leading to this object

is_temporary

bool

True if this was a temporary object

object_type

text

Type of the object

schema_name

text

Name of the schema the object belonged in, if any; otherwise NULL. No quoting is applied.

object_name

text

Name of the object, if the combination of schema and name can be used as a unique identifier for the object; otherwise NULL. No quoting is applied, and name is never schema-qualified.

object_identity

text

Text rendering of the object identity, schema-qualified. Each identifier included in the identity is quoted if necessary.

address_names

text[]

An array that, together with object_type and address_args, can be used by the pg_get_object_address() function to recreate the object address in a remote server containing an identically named object of the same kind

address_args

text[]

Complement for address_names

Name

Return Type

Description

pg_event_trigger_table_rewrite_oid()

Oid

The OID of the table about to be rewritten.

pg_event_trigger_table_rewrite_reason()

int

The reason code(s) explaining the reason for rewriting. The exact meaning of the codes is release dependent.