git.postgresql.org Git - users/bernd/postgres.git/commit

projects / users / bernd / postgres.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: 6bad580) | patch

author	Peter Eisentraut <peter_e@gmx.net>
	Thu, 6 Apr 2017 12:33:16 +0000 (08:33 -0400)
committer	Peter Eisentraut <peter_e@gmx.net>
	Thu, 6 Apr 2017 12:41:37 +0000 (08:41 -0400)
commit	3217327053638085d24dd4d276e7c1f7ac2c4c6b
tree	513d1264a2935b05e28b0d8322d73a0411a3d02f	tree
parent	6bad580d9e678a0b604883e14d8401d469b06566	commit \| diff

Identity columns

This is the SQL standard-conforming variant of PostgreSQL's serial
columns. It fixes a few usability issues that serial columns have:

- CREATE TABLE / LIKE copies default but refers to same sequence
- cannot add/drop serialness with ALTER TABLE
- dropping default does not drop sequence
- need to grant separate privileges to sequence
- other slight weirdnesses because serial is some kind of special macro

Reviewed-by: Vitaly Burovoy <vitaly.burovoy@gmail.com>

57 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/information_schema.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/alter_table.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/copy.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/create_table.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/insert.sgml		diff \| blob \| blame \| history
src/backend/access/common/tupdesc.c		diff \| blob \| blame \| history
src/backend/catalog/dependency.c		diff \| blob \| blame \| history
src/backend/catalog/genbki.pl		diff \| blob \| blame \| history
src/backend/catalog/heap.c		diff \| blob \| blame \| history
src/backend/catalog/index.c		diff \| blob \| blame \| history
src/backend/catalog/information_schema.sql		diff \| blob \| blame \| history
src/backend/catalog/pg_depend.c		diff \| blob \| blame \| history
src/backend/catalog/sql_features.txt		diff \| blob \| blame \| history
src/backend/commands/sequence.c		diff \| blob \| blame \| history
src/backend/commands/tablecmds.c		diff \| blob \| blame \| history
src/backend/executor/execExpr.c		diff \| blob \| blame \| history
src/backend/executor/execExprInterp.c		diff \| blob \| blame \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/nodeFuncs.c		diff \| blob \| blame \| history
src/backend/nodes/outfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/readfuncs.c		diff \| blob \| blame \| history
src/backend/parser/analyze.c		diff \| blob \| blame \| history
src/backend/parser/gram.y		diff \| blob \| blame \| history
src/backend/parser/parse_utilcmd.c		diff \| blob \| blame \| history
src/backend/rewrite/rewriteHandler.c		diff \| blob \| blame \| history
src/backend/utils/adt/ruleutils.c		diff \| blob \| blame \| history
src/backend/utils/cache/lsyscache.c		diff \| blob \| blame \| history
src/backend/utils/cache/relcache.c		diff \| blob \| blame \| history
src/backend/utils/errcodes.txt		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.h		diff \| blob \| blame \| history
src/bin/pg_dump/t/002_pg_dump.pl		diff \| blob \| blame \| history
src/bin/psql/describe.c		diff \| blob \| blame \| history
src/bin/psql/tab-complete.c		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/dependency.h		diff \| blob \| blame \| history
src/include/catalog/pg_attribute.h		diff \| blob \| blame \| history
src/include/catalog/pg_class.h		diff \| blob \| blame \| history
src/include/commands/sequence.h		diff \| blob \| blame \| history
src/include/executor/execExpr.h		diff \| blob \| blame \| history
src/include/nodes/nodes.h		diff \| blob \| blame \| history
src/include/nodes/parsenodes.h		diff \| blob \| blame \| history
src/include/nodes/primnodes.h		diff \| blob \| blame \| history
src/include/parser/kwlist.h		diff \| blob \| blame \| history
src/include/utils/lsyscache.h		diff \| blob \| blame \| history
src/test/regress/expected/create_table_like.out		diff \| blob \| blame \| history
src/test/regress/expected/identity.out	[new file with mode: 0644]	blob
src/test/regress/expected/sequence.out		diff \| blob \| blame \| history
src/test/regress/expected/truncate.out		diff \| blob \| blame \| history
src/test/regress/parallel_schedule		diff \| blob \| blame \| history
src/test/regress/serial_schedule		diff \| blob \| blame \| history
src/test/regress/sql/create_table_like.sql		diff \| blob \| blame \| history
src/test/regress/sql/identity.sql	[new file with mode: 0644]	blob
src/test/regress/sql/sequence.sql		diff \| blob \| blame \| history
src/test/regress/sql/truncate.sql		diff \| blob \| blame \| history

Bernd Helmle's repository