SQLERRM/SQLSTATE for pl/pgsql
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.
Procedural Languages
Description
allows simple access to the SQL error state and the associated error text if an exception happened
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 15
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "sqlerrmsqlstate-for-plpgsql",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "SQLERRM/SQLSTATE for pl/pgsql",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "SQLERRM/SQLSTATE for pl/pgsql",
"NameLocale": "en",
"GroupKey": "procedural-languages",
"GroupName": "Procedural Languages",
"GroupLocale": "en",
"Ordinal": 19,
"GroupOrder": 19,
"Facts": {
"feature": {
"description": "allows simple access to the SQL error state and the associated error text if an exception happened",
"name": "SQLERRM/SQLSTATE for pl/pgsql",
"versions": {
"8.1": "Yes"
}
},
"group": "Procedural Languages",
"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": "SQLERRM/SQLSTATE for pl/pgsql",
"BodyHTML": "\u003cp\u003eallows simple access to the SQL error state and the associated error text if an exception happened\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "ba3c44d08d908277c52667dc1ff191ab168fac9722005dd57ff983f0f2d19d0f",
"Payload": {
"description": "allows simple access to the SQL error state and the associated error text if an exception happened",
"name": "SQLERRM/SQLSTATE for pl/pgsql",
"versions": {
"8.1": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "pl/pgsql 的 SQLERRM/SQLSTATE",
"BodyHTML": "\u003cp\u003e允许在发生异常时简单访问 SQL 错误状态和相关的错误文本\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "3df33fc75b12cc19596c01b5b0a73f16d2f1c88e1933cbb51f8a6df5c11ef3fc",
"Payload": {
"description": "允许在发生异常时简单访问 SQL 错误状态和相关的错误文本",
"name": "pl/pgsql 的 SQLERRM/SQLSTATE"
}
}
],
"GroupTitles": {
"en": "Procedural Languages",
"zh-Hans": "过程语言"
},
"LegacyIDs": [
"15"
]
}