September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.4 / 7.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

C.2. Unsupported Features

The following features defined in SQL99 are not implemented in the current release of PostgreSQL. In a few cases, equivalent functionality is available.

Identifier Package Description Comment
B011 Core Embedded Ada  
B013 Core Embedded COBOL  
B014 Core Embedded Fortran  
B015 Core Embedded MUMPS  
B016 Core Embedded Pascal  
B017 Core Embedded PL/I  
B031   Basic dynamic SQL  
B032   Extended dynamic SQL  
B032-1   <describe input> statement  
B041   Extensions to embedded SQL exception declarations  
B051   Enhanced execution rights  
E081 Core Basic Privileges  
E081-05 Core UPDATE privilege at the column level  
E081-07 Core REFERENCES privilege at the column level  
E081-08 Core WITH GRANT OPTION  
E121 Core Basic cursor support  
E121-04 Core OPEN statement (cursor)
E121-06 Core Positioned UPDATE statement (cursor)
E121-07 Core Positioned DELETE statement (cursor)
E121-17 Core WITH HOLD cursors Cursor to stay open across transactions
E152 Core Basic SET TRANSACTION statement  
E152-02 Core SET TRANSACTION statement: READ ONLY and READ WRITE clauses Syntax accepted; READ ONLY not supported
E153 Core Updatable queries with subqueries  
E171 Core SQLSTATE support  
F181   Multiple module support  
E182 Core Module language  
F021 Core Basic information schema  
F021-01 Core COLUMNS view  
F021-02 Core TABLES view  
F021-03 Core VIEWS view  
F021-04 Core TABLE_CONSTRAINTS view  
F021-05 Core REFERENTIAL_CONSTRAINTS view  
F021-06 Core CHECK_CONSTRAINTS view  
F031-19 Core REVOKE statement: RESTRICT clause  
F034   Extended REVOKE statement  
F034-01   REVOKE statement performed by other than the owner of a schema object  
F034-02   REVOKE statement: GRANT OPTION FOR clause  
F034-03   REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION  
F111   Isolation levels other than SERIALIZABLE  
F111-01   READ UNCOMMITTED isolation level  
F111-03   REPEATABLE READ isolation level  
F121   Basic diagnostics management  
F121-01   GET DIAGNOSTICS statement  
F121-02   SET TRANSACTION statement: DIAGNOSTICS SIZE clause  
F231   Privilege Tables  
F231-01   TABLE_PRIVILEGES view  
F231-02   COLUMN_PRIVILEGES view  
F231-03   USAGE_PRIVILEGES view  
F291   UNIQUE predicate  
F301   CORRESPONDING in query expressions  
F311-04 Core CREATE VIEW: WITH CHECK OPTION  
F341   Usage tables  
F431   Read-only scrollable cursors  
F431-02   FETCH FIRST  
F431-03   FETCH LAST  
F431-05   FETCH ABSOLUTE  
F451   Character set definition  
F461   Named character sets  
F501 Core Features and conformance views  
F501-01 Core SQL_FEATURES view  
F501-02 Core SQL_SIZING view  
F501-03 Core SQL_LANGUAGES view  
F502   Enhanced documentation tables  
F502-01   SQL_SIZING_PROFILES view  
F502-02   SQL_IMPLEMENTATION_INFO view  
F502-03   SQL_PACKAGES view  
F521 Enhanced integrity management Assertions  
F641 OLAP facilities Row and table constructors  
F661   Simple tables  
F671 Enhanced integrity management Subqueries in CHECK intentionally omitted
F691   Collation and translation  
F711   ALTER domain  
F721   Deferrable constraints foreign keys only
F731   INSERT column privileges  
F741   Referential MATCH types no partial match yet
F751   View CHECK enhancements  
F771   Connection management  
F781   Self-referencing operations  
F811   Extended flagging  
F812 Core Basic flagging  
F813   Extended flagging for "Core SQL Flagging" and "Catalog Lookup" only  
F821   Local table references  
F831   Full cursor update  
F831-01   Updatable scrollable cursors  
F831-02   Updatable ordered cursors  
S011 Core Distinct data types  
S011-01 Core USER_DEFINED_TYPES view  
S023 Basic object support, SQL/MM support Basic structured types  
S024, SQL/MM support Enhanced object support Enhanced structured types  
S041 Basic object support Basic reference types  
S043 Enhanced object support Enhanced reference types  
S051 Basic object support Create table of type  
S081 Enhanced object support Subtables  
S091 SQL/MM support Basic array support PostgreSQL arrays are different
S091-01 SQL/MM support Arrays of built-in data types  
S091-02 SQL/MM support Arrays of distinct types  
S091-03 SQL/MM support Array expressions  
S092 SQL/MM support Arrays of user-defined types  
S094   Arrays of reference types  
S151 Basic object support Type predicate IS OF
S161 Enhanced object support Subtype treatment TREAT(expr AS type)
S201   SQL routines on arrays  
S201-01   Array parameters  
S201-02   Array as result type of functions  
S231 Enhanced object support Structured type locators  
S232   Array locators  
S241 Enhanced object support Transform functions  
S251   User-defined orderings CREATE ORDERING FOR
S261   Specific type method  
T011   Timestamp in Information Schema  
T041 Basic object support Basic LOB data type support  
T041-01 Basic object support BLOB data type  
T041-02 Basic object support CLOB data type  
T041-03 Basic object support POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types  
T041-04 Basic object support Concatenation of LOB data types  
T041-05 Basic object support LOB locator: non-holdable  
T042   Extended LOB data type support  
T051   Row types  
T111   Updatable joins, unions, and columns  
T121   WITH (excluding RECURSIVE) in query expression  
T131   Recursive query  
T171   LIKE clause in table definition CREATE TABLE T1 (LIKE T2)
T211 Enhanced integrity management, Active database Basic trigger capability  
T211-05 Enhanced integrity management Ability to specify a search condition that must be true before the trigger is invoked  
T211-06 Enhanced integrity management Support for run-time rules for the interaction of triggers and constraints  
T211-08 Enhanced integrity management Multiple triggers for the same the event are executed in the order in which they were created  
T212 Enhanced integrity management Enhanced trigger capability  
T251   SET TRANSACTION statement: LOCAL option  
T261   Chained transactions  
T271   Savepoints  
T281   SELECT privilege with column granularity  
T301   Functional Dependencies  
T321 Core Basic SQL-invoked routines  
T321-02 Core User-defined stored procedures with no overloading  
T321-04 Core CALL statement  
T321-05 Core RETURN statement  
T321-06 Core ROUTINES view  
T321-07 Core PARAMETERS view  
T331   Basic roles  
T332   Extended roles  
T401   INSERT into a cursor  
T411   UPDATE statement: SET ROW option  
T431 OLAP facilities CUBE and ROLLUP operations  
T461   Symmetric BETWEEN predicate  
T471   Result sets return value  
T491   LATERAL derived table  
T511   Transaction counts  
T541   Updatable table references  
T561   Holdable locators  
T571   Array-returning external SQL-invoked functions  
T601   Local cursor references