Search PostgreSQL documentation

NotesManual ChaptersPG18Notes Since a cursor can only persist within a transaction, dblink_open starts an explicit transaction block (BEGIN) on the remote side, if the remote side was not already within a transacti…Notes NotesManual ChaptersPG18F.10.5. Notes For examples of usage, see the regression test sql/cube.sql. To make it harder for people to break things, there is a limit of 100 on the number of dimensions of cubes. This is…Notes NotesManual ChaptersPG18Notes This association is valid only if the declaration is physically placed on top of a dynamic statement.Notes NotesManual ChaptersPG18Notes In typical usage, the string is a host variable reference to a string containing a dynamically-constructed SQL statement. The case of a literal string is not very useful; you might as …Notes NotesManual ChaptersPG18Notes In typical usage, the string is a host variable reference to a string containing a dynamically-constructed SQL statement. The case of a literal string is not very useful; you might as …Notes NotesManual ChaptersPG18Notes oid2name requires a running database server with non-corrupt system catalogs. It is therefore of only limited use for recovering from catastrophic database corruption situations.Notes NotesManual ChaptersPG18Notes pg_archivecleanup is designed to work with PostgreSQL 8.0 and later when used as a standalone utility, or with PostgreSQL 9.0 and later when used as an archive cleanup command. pg_arch…Notes NotesManual ChaptersPG18NotesNotes NotesManual ChaptersPG18F.26.8. NotesNotes NotesManual ChaptersPG18Notes pg_upgrade creates various working files, such as schema dumps, stored within pg_upgrade_output.d in the directory of the new cluster. Each run creates a new subdirectory named with a …Notes NotesManual ChaptersPG18Notes Can give wrong results when the server is running. Only the specified timeline is displayed (or the default, if none is specified). Records in other timelines are ignored. pg_waldump c…Notes NotesManual ChaptersPG18F.39.5. Notes For examples of usage, see the regression test sql/seg.sql. The mechanism that converts (+-) to regular ranges isn't completely accurate in determining the number of significan…Notes NotesManual ChaptersPG18Notes Fetching backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option.Notes NotesManual ChaptersPG18Notes Beware that this function can return a Portal object that does not have cursor-like properties; for example it might not return tuples. If you simply pass the Portal pointer to other S…Notes NotesManual ChaptersPG18Notes Moving backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option.Notes NotesManual ChaptersPG18Notes All SPI query-execution functions set both SPI_processed and SPI_tuptable (just the pointer, not the contents of the structure). Save these two global variables into local C function v…Notes NotesManual ChaptersPG18Notes The passed-in statement is relocated to permanent storage by means of pointer adjustment (no data copying is required). If you later wish to delete it, use SPI_freeplan on it.Notes NotesManual ChaptersPG18Notes Useful bits to set in cursorOptions include CURSOR_OPT_SCROLL, CURSOR_OPT_NO_SCROLL, CURSOR_OPT_FAST_PLAN, CURSOR_OPT_GENERIC_PLAN, and CURSOR_OPT_CUSTOM_PLAN. Note in particular that …Notes NotesManual ChaptersPG18Notes If no parameters are defined, a generic plan will be created at the first use of SPI_execute_plan, and used for all subsequent executions as well. If there are parameters, the first fe…Notes NotesManual ChaptersPG18Notes The originally passed-in statement is not freed, so you might wish to do SPI_freeplan on it to avoid leaking memory until SPI_finish. In most cases, SPI_keepplan is preferred to this f…Notes NotesManual ChaptersPG18Notes See the SQL FETCH command for details of the interpretation of the direction and count parameters. Direction values other than FETCH_FORWARD may fail if the cursor's plan was not creat…Notes NotesManual ChaptersPG18Notes See the SQL FETCH command for details of the interpretation of the direction and count parameters. Direction values other than FETCH_FORWARD may fail if the cursor's plan was not creat…Notes NotesManual ChaptersPG18Notes Use COMMIT to successfully terminate a transaction. Issuing ABORT outside of a transaction block emits a warning and otherwise has no effect.Notes NotesManual ChaptersPG18Notes The recommended syntax for referencing an ordered-set aggregate is to write ORDER BY between the direct and aggregated argument specifications, in the same style as in CREATE AGGREGATE…Notes NotesManual ChaptersPG18Notes When a collation object is created, the provider-specific version of the collation is recorded in the system catalog. When the collation is used, the current version is checked against…Notes NotesManual ChaptersPG18Notes It is also possible to tie a session default to a specific role rather than to a database; see ALTER ROLE. Role-specific settings override database-specific ones if there is a conflict…Notes NotesManual ChaptersPG18Notes Use psql's \ddp command to obtain information about existing assignments of default privileges. The meaning of the privilege display is the same as explained for \dp in Section 5.8. If…Notes NotesManual ChaptersPG18Notes Although ALTER DOMAIN ADD CONSTRAINT attempts to verify that existing stored data satisfies the new constraint, this check is not bulletproof, because the command cannot “see” table ro…Notes NotesManual ChaptersPG18Notes The key word COLUMN is noise and can be omitted. Consistency with the foreign server is not checked when a column is added or removed with ADD COLUMN or DROP COLUMN, a NOT NULL or CHEC…Notes NotesManual ChaptersPG18Notes These operations are also possible using ALTER TABLE. ALTER INDEX is in fact just an alias for the forms of ALTER TABLE that apply to indexes. There was formerly an ALTER INDEX OWNER v…Notes NotesManual ChaptersPG18Notes Refer to Section 36.14 and Section 36.15 for further information. Since commutators come in pairs that are commutators of each other, ALTER OPERATOR SET COMMUTATOR will also set the co…Notes NotesManual ChaptersPG18Notes Notice that the DROP syntax only specifies the “slot” in the operator family, by strategy or support number and input data type(s). The name of the operator or function occupying the s…Notes NotesManual ChaptersPG18Notes Use CREATE ROLE to add new roles, and DROP ROLE to remove a role. ALTER ROLE cannot change a role's memberships. Use GRANT and REVOKE to do that. Caution must be exercised when specify…Notes NotesManual ChaptersPG18Notes ALTER SEQUENCE will not immediately affect nextval results in backends, other than the current one, that have preallocated (cached) sequence values. They will use up all cached values …Notes NotesManual ChaptersPG18Notes This command can't be used to set data_directory, allow_alter_system, nor parameters that are not allowed in postgresql.conf (e.g., preset options). See Section 19.1 for other ways to …Notes NotesManual ChaptersPG18Notes The key word COLUMN is noise and can be omitted. When a column is added with ADD COLUMN and a non-volatile DEFAULT is specified, the default value is evaluated at the time of the state…Notes NotesManual ChaptersPG18Notes The ability to temporarily enable or disable a trigger is provided by ALTER TABLE, not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling o…Notes NotesManual ChaptersPG18Notes If ALTER TYPE ... ADD VALUE (the form that adds a new value to an enum type) is executed inside a transaction block, the new value cannot be used until after the transaction has been c…Notes NotesManual ChaptersPG18Notes For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equivalent to the ones shown above.Notes NotesManual ChaptersPG18Notes To analyze a table, one must ordinarily have the MAINTAIN privilege on the table. However, database owners are allowed to analyze all tables in their databases, except shared catalogs.…Notes