↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

Statement level triggers

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

Custom Functions, Stored Procedures, & Triggers

Description

Triggers that fire on a per statement level instead of a per row level

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 73

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "statement-level-triggers",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Statement level triggers",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Statement level triggers",
  "NameLocale": "en",
  "GroupKey": "custom-functions-stored-procedures-triggers",
  "GroupName": "Custom Functions, Stored Procedures, \u0026 Triggers",
  "GroupLocale": "en",
  "Ordinal": 13,
  "GroupOrder": 18,
  "Facts": {
    "feature": {
      "description": "Triggers that fire on a per statement level instead of a per row level",
      "name": "Statement level triggers",
      "versions": {
        "8.1": "Yes"
      }
    },
    "group": "Custom Functions, Stored Procedures, \u0026 Triggers",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "14",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.2",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.3",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.4",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.0",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Statement level triggers",
      "BodyHTML": "\u003cp\u003eTriggers that fire on a per statement level instead of a per row level\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "766691c3de6001181f92b0b05d7c7e2b5791115a0fa3138484637d0c1ede13fa",
      "Payload": {
        "description": "Triggers that fire on a per statement level instead of a per row level",
        "name": "Statement level triggers",
        "versions": {
          "8.1": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "语句级触发器",
      "BodyHTML": "\u003cp\u003e在语句级别而非行级别触发的触发器\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "6af8ae6037165cb449c75f8f11f7211d35e459146607875b9feb27aaa18cf924",
      "Payload": {
        "description": "在语句级别而非行级别触发的触发器",
        "name": "语句级触发器"
      }
    }
  ],
  "GroupTitles": {
    "en": "Custom Functions, Stored Procedures, \u0026 Triggers",
    "zh-Hans": "自定义函数、存储过程和触发器"
  },
  "LegacyIDs": [
    "73"
  ]
}

Complete source data JSON