Expand description
PostgreSQL column-name and stored-type declaration rules.
Modules§
- addition
- Bind an added column against current defaults, CHECKs, generated expressions, and foreign keys.
- alteration
- Analyze altered column expressions and types against ordered catalog snapshots.
- publication
- Mutate a declared column candidate before its catalog publication.
- removal_
metadata - Validate column dependencies against retained relation metadata and remove local declarations.
- type_
target - Ordered checks of an ALTER COLUMN TYPE target before its new type is resolved.
- type_
transform - USING expression analysis and assignment compatibility over the original row type.
Constants§
Functions§
- altered_
column - The column an
ALTER TABLE ... ALTER COLUMNaction names, asget_attnumfinds it forATExecColumnDefaultand its siblings. - append_
registered_ column - Append a declared column after checking its name against the existing schema.
- missing_
altered_ column - The error for an
ALTER COLUMNtarget that is not a column of the relation: every relation has the system columns, which cannot be altered, and any other name does not exist. - missing_
drop_ column_ notice - The notice for a missing column, using the unqualified name of the already bound relation.
- undefined_
relation_ column column "x" of relation "t" does not exist, whichALTER TABLEreports for a column the relation lacks.- validate_
default_ change ATExecColumnDefault’s checks of the column whose defaultSET DEFAULT(setting) orDROP DEFAULTchanges: an identity column takes its values from its sequence and a generated column from its expression.- validate_
drop_ column - Check a DROP target before dependency traversal. Missing
IF EXISTStargets return false so execution can publish its notice without changing the relation. - validate_
postgres_ column_ name - validate_
postgres_ relation_ column_ type