aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/alter_table.sgml
Commit message (Expand)AuthorAge
* Add the notion of REPLICA IDENTITY for a table.Robert Haas2013-11-08
* ALTER TABLE ... ALTER CONSTRAINT for FKsSimon Riggs2013-06-29
* Reverting previous commit, pending investigationSimon Riggs2013-06-24
* ALTER TABLE ... ALTER CONSTRAINT for FKsSimon Riggs2013-06-24
* Fix docs on lock level for ALTER TABLE VALIDATESimon Riggs2013-06-18
* Support automatically-updatable views.Tom Lane2012-12-08
* Provide adequate documentation of the "table_name *" notation.Tom Lane2012-09-17
* Change syntax of new CHECK NO INHERIT constraintsAlvaro Herrera2012-07-24
* Make placeholders in SQL command help more consistent and precisePeter Eisentraut2012-06-22
* Adjust documentation of ALTER TABLE CLUSTER ON for more consistency.Tom Lane2012-05-21
* Minor improvements for CHECK NO INHERIT documentation.Robert Haas2012-04-23
* Recast "ONLY" column CHECK constraints as NO INHERITAlvaro Herrera2012-04-20
* Add support for renaming constraintsPeter Eisentraut2012-03-10
* ALTER <thing> [IF EXISTS] ... allows silent DDL if required,Simon Riggs2012-01-23
* Disallow merging ONLY constraints in children tablesAlvaro Herrera2012-01-16
* Add support for privileges on typesPeter Eisentraut2011-12-20
* Allow CHECK constraints to be declared ONLYAlvaro Herrera2011-12-19
* Remove unnecessary MATCH FULL specification in example.Bruce Momjian2011-09-10
* Fix a whitespace issue with the man pagesPeter Eisentraut2011-08-07
* Enable CHECK constraints to be declared NOT VALIDAlvaro Herrera2011-06-30
* Rework parsing of ConstraintAttributeSpec to improve NOT VALID handling.Tom Lane2011-06-15
* Allow ALTER TABLE name {OF type | NOT OF}.Robert Haas2011-04-20
* Remove collation information from TypeName, where it does not belong.Tom Lane2011-03-09
* Avoid a few more SET DATA TYPE table rewrites.Robert Haas2011-02-14
* Teach ALTER TABLE .. SET DATA TYPE to avoid some table rewrites.Robert Haas2011-02-12
* Extend ALTER TABLE to allow Foreign Keys to be added without initial validation.Simon Riggs2011-02-08
* Update ALTER TABLE docs to mention using VACUUM FULL for rewrites.Robert Haas2011-02-04
* Make 'on' uppercase in a sql example.Itagaki Takahiro2011-01-26
* Correct ALTER TYPE -> SET DATA TYPE in ALTER TABLE documentation.Robert Haas2011-01-25
* Implement ALTER TABLE ADD UNIQUE/PRIMARY KEY USING INDEX.Tom Lane2011-01-25
* Reclassify DEFAULT as a column_constraint item in the CREATE TABLE syntax.Tom Lane2010-12-28
* Remove cvs keywords from all files.Magnus Hagander2010-09-20
* Stamp 9.0 release notes with expected release date; also some last-minuteTom Lane2010-09-16
* Mention that when alter rewrites a table, indexes are also rebuilt.Bruce Momjian2010-06-24
* Update ALTER TABLE docs to account for exclusion and deferrable uniquenessAlvaro Herrera2010-06-09
* Use "TOAST table" in place of the vague, not-used-elsewhere phraseTom Lane2010-05-13
* Remove unnecessary xref endterm attributes and title idsPeter Eisentraut2010-04-03
* Fix mismatched tags introduced by attribute options patch.Robert Haas2010-01-22
* Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism.Robert Haas2010-01-22
* Easier to translate psql helpPeter Eisentraut2009-09-18
* Add ALTER TABLE ... ALTER COLUMN ... SET STATISTICS DISTINCTTom Lane2009-08-02
* DROP IF EXISTS for columns and constraints. Andres Freund.Andrew Dunstan2009-07-20
* Fix unintelligible description created by removing only part ofTom Lane2009-05-03
* Remove mention of pre-7.1 inheritance behavior from /ref pages; keepBruce Momjian2009-04-15
* Change ALTER TABLE SET WITHOUT OIDS to rewrite the whole table to physicallyTom Lane2009-02-11
* Update autovacuum to use reloptions instead of a system catalog, forAlvaro Herrera2009-02-09
* Increase the default value of default_statistics_target from 10 to 100,Tom Lane2008-12-13
* Set SQL man pages to be section 7 by default, and only transform them toPeter Eisentraut2008-11-14
* Allow SQL:2008 syntax ALTER TABLE ... ALTER COLUMN ... SET DATA TYPEPeter Eisentraut2008-10-21
* Change the rules for inherited CHECK constraints to be essentially the sameTom Lane2008-05-09
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 20:25:41 +0000