SP-GiST offers an interface with a high level of abstraction, requiring the access method developer to implement only methods specific to

NameSET SESSION AUTHORIZATION -- set the session user identifier and the current user identifier of the current session

The specific function that is referenced by a function call is determined using the following procedure. Function

All messages emitted by the PostgreSQL server are assigned five-character error codes that follow the SQL standard's conventions for

The view pg_indexes provides access to useful information about each index in the database.

LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query:

NameALTER FUNCTION -- change the definition of a function Synopsis

NameALTER INDEX -- change the definition of an index Synopsis

NameDROP TRANSFORM -- remove a transform Synopsis

Though PostgreSQL provides nonblocking read/write access to table data, nonblocking read/write access is not currently offered for every index