git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 6b8b536) | patch
Generated columns
2019年3月30日 07:13:09 +0000 (08:13 +0100)
2019年3月30日 07:15:57 +0000 (08:15 +0100)
commit fc22b6623b6b3bab3cb057ccd282c2bfad1a0b30
Generated columns

This is an SQL-standard feature that allows creating columns that are
computed from expressions rather than assigned, similar to a view or
materialized view but on a column basis.

This implements one kind of generated column: stored (computed on
write). Another kind, virtual (computed on read), is planned for the
future, and some room is left for it.

Reviewed-by: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/b151f851-4019-bdb1-699e-ebab07d2f40a@2ndquadrant.com
84 files changed:
contrib/postgres_fdw/expected/postgres_fdw.out diff | blob | blame | history
contrib/postgres_fdw/postgres_fdw.c diff | blob | blame | history
contrib/postgres_fdw/sql/postgres_fdw.sql diff | blob | blame | history
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/ddl.sgml diff | blob | blame | history
doc/src/sgml/information_schema.sgml diff | blob | blame | history
doc/src/sgml/protocol.sgml diff | blob | blame | history
doc/src/sgml/ref/copy.sgml diff | blob | blame | history
doc/src/sgml/ref/create_foreign_table.sgml diff | blob | blame | history
doc/src/sgml/ref/create_table.sgml diff | blob | blame | history
doc/src/sgml/ref/create_trigger.sgml diff | blob | blame | history
doc/src/sgml/textsearch.sgml diff | blob | blame | history
doc/src/sgml/trigger.sgml diff | blob | blame | history
src/backend/access/common/tupdesc.c diff | blob | blame | history
src/backend/catalog/heap.c diff | blob | blame | history
src/backend/catalog/information_schema.sql diff | blob | blame | history
src/backend/commands/copy.c diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/commands/trigger.c diff | blob | blame | history
src/backend/commands/typecmds.c diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/executor/execReplication.c diff | blob | blame | history
src/backend/executor/nodeModifyTable.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/outfuncs.c diff | blob | blame | history
src/backend/nodes/readfuncs.c diff | blob | blame | history
src/backend/optimizer/plan/createplan.c diff | blob | blame | history
src/backend/optimizer/util/inherit.c diff | blob | blame | history
src/backend/optimizer/util/plancat.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_agg.c diff | blob | blame | history
src/backend/parser/parse_expr.c diff | blob | blame | history
src/backend/parser/parse_func.c diff | blob | blame | history
src/backend/parser/parse_relation.c diff | blob | blame | history
src/backend/parser/parse_utilcmd.c diff | blob | blame | history
src/backend/replication/logical/proto.c diff | blob | blame | history
src/backend/replication/logical/relation.c diff | blob | blame | history
src/backend/replication/logical/tablesync.c diff | blob | blame | history
src/backend/replication/logical/worker.c diff | blob | blame | history
src/backend/replication/pgoutput/pgoutput.c diff | blob | blame | history
src/backend/rewrite/rewriteHandler.c diff | blob | blame | history
src/backend/utils/cache/lsyscache.c diff | blob | blame | history
src/backend/utils/cache/partcache.c diff | blob | blame | history
src/backend/utils/cache/relcache.c 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/pg_dump_sort.c 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/include/access/tupdesc.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/heap.h diff | blob | blame | history
src/include/catalog/pg_attribute.h diff | blob | blame | history
src/include/catalog/pg_class.dat diff | blob | blame | history
src/include/executor/nodeModifyTable.h diff | blob | blame | history
src/include/nodes/execnodes.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/include/optimizer/plancat.h diff | blob | blame | history
src/include/parser/kwlist.h diff | blob | blame | history
src/include/parser/parse_node.h diff | blob | blame | history
src/include/utils/lsyscache.h diff | blob | blame | history
src/pl/plperl/expected/plperl_trigger.out diff | blob | blame | history
src/pl/plperl/plperl.c diff | blob | blame | history
src/pl/plperl/sql/plperl_trigger.sql diff | blob | blame | history
src/pl/plpgsql/src/pl_exec.c diff | blob | blame | history
src/pl/plpython/expected/plpython_trigger.out diff | blob | blame | history
src/pl/plpython/plpy_cursorobject.c diff | blob | blame | history
src/pl/plpython/plpy_exec.c diff | blob | blame | history
src/pl/plpython/plpy_spi.c diff | blob | blame | history
src/pl/plpython/plpy_typeio.c diff | blob | blame | history
src/pl/plpython/plpy_typeio.h diff | blob | blame | history
src/pl/plpython/sql/plpython_trigger.sql diff | blob | blame | history
src/pl/tcl/expected/pltcl_trigger.out diff | blob | blame | history
src/pl/tcl/pltcl.c diff | blob | blame | history
src/pl/tcl/sql/pltcl_trigger.sql diff | blob | blame | history
src/test/regress/expected/create_table_like.out diff | blob | blame | history
src/test/regress/expected/generated.out [new file with mode: 0644] blob
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/generated.sql [new file with mode: 0644] blob
src/test/subscription/t/011_generated.pl [new file with mode: 0644] blob
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /