Horton

Automatic view update rules

Peter Eisentraut <peter_e@gmx.net>

View on postgr.es
Commit: dd7e54a17ffed5767cd9af175024c60df2b1951c
Author: Peter Eisentraut <peter_e@gmx.net>
Date: 2009-01-22T17:27:55Z
Releases: 8.4.0 
Automatic view update rules

Bernd Helmle

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +8 −1
doc/src/sgml/intro.sgml modified +2 −2
doc/src/sgml/ref/create_view.sgml modified +94 −6
src/backend/commands/view.c modified +20 −3
src/backend/rewrite/Makefile modified +3 −2
src/backend/rewrite/rewriteDefine.c modified +64 −2
src/backend/rewrite/rewriteHandler.c modified +7 −7
src/backend/rewrite/rewriteRemove.c modified +34 −1
src/backend/rewrite/viewUpdate.c added +1401 −0
src/backend/utils/cache/relcache.c modified +4 −1
src/bin/pg_dump/pg_dump.c modified +12 −2
src/bin/pg_dump/pg_dump.h modified +1 −2
src/include/catalog/pg_rewrite.h modified +14 −4
src/include/rewrite/prs2lock.h modified +2 −1
src/include/rewrite/rewriteDefine.h modified +2 −1
src/include/rewrite/rewriteRemove.h modified +2 −1
src/include/rewrite/viewUpdate.h added +21 −0
src/test/regress/expected/alter_table.out modified +5 −0
src/test/regress/expected/create_view.out modified +18 −0
src/test/regress/expected/drop_if_exists.out modified +1 −0
src/test/regress/expected/plancache.out modified +7 −0
src/test/regress/expected/portals.out modified +1 −0
src/test/regress/expected/privileges.out modified +4 −0
src/test/regress/expected/returning.out modified +1 −0
src/test/regress/expected/rules.out modified +17 −3
src/test/regress/expected/subselect.out modified +1 −0
src/test/regress/expected/view_update.out added +370 −0
src/test/regress/parallel_schedule modified +3 −1
src/test/regress/serial_schedule modified +2 −1
src/test/regress/sql/view_update.sql added +168 −0