git.osdn.net Git - pg-rex/syncrep.git/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 29 Sep 2000 18:21:41 +0000 (18:21 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Fri, 29 Sep 2000 18:21:41 +0000 (18:21 +0000)
commit	3a94e789f5c9537d804210be3cb26f7fb08e3b9e
tree	f1eac12405e3c0ded881d7dd7e59cec35b30c335	tree \| snapshot
parent	6f64c2e54a0b14154a335249f4dca91a39c61c50	commit \| diff

Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.
(Don't forget that an alias is required.)  Views reimplemented as expanding
to subselect-in-FROM.  Grouping, aggregates, DISTINCT in views actually
work now (he says optimistically).  No UNION support in subselects/views
yet, but I have some ideas about that.  Rule-related permissions checking
moved out of rewriter and into executor.
INITDB REQUIRED!

77 files changed:

src/backend/catalog/heap.c		diff \| blob \| history
src/backend/commands/command.c		diff \| blob \| history
src/backend/commands/explain.c		diff \| blob \| history
src/backend/commands/view.c		diff \| blob \| history
src/backend/executor/Makefile		diff \| blob \| history
src/backend/executor/execAmi.c		diff \| blob \| history
src/backend/executor/execMain.c		diff \| blob \| history
src/backend/executor/execProcnode.c		diff \| blob \| history
src/backend/executor/execTuples.c		diff \| blob \| history
src/backend/executor/nodeSubqueryscan.c	[new file with mode: 0644]	blob
src/backend/nodes/copyfuncs.c		diff \| blob \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| history
src/backend/nodes/list.c		diff \| blob \| history
src/backend/nodes/outfuncs.c		diff \| blob \| history
src/backend/nodes/print.c		diff \| blob \| history
src/backend/nodes/readfuncs.c		diff \| blob \| history
src/backend/optimizer/README		diff \| blob \| history
src/backend/optimizer/geqo/geqo_main.c		diff \| blob \| history
src/backend/optimizer/path/allpaths.c		diff \| blob \| history
src/backend/optimizer/path/costsize.c		diff \| blob \| history
src/backend/optimizer/path/indxpath.c		diff \| blob \| history
src/backend/optimizer/path/joinpath.c		diff \| blob \| history
src/backend/optimizer/path/joinrels.c		diff \| blob \| history
src/backend/optimizer/path/pathkeys.c		diff \| blob \| history
src/backend/optimizer/plan/createplan.c		diff \| blob \| history
src/backend/optimizer/plan/initsplan.c		diff \| blob \| history
src/backend/optimizer/plan/planmain.c		diff \| blob \| history
src/backend/optimizer/plan/planner.c		diff \| blob \| history
src/backend/optimizer/plan/setrefs.c		diff \| blob \| history
src/backend/optimizer/plan/subselect.c		diff \| blob \| history
src/backend/optimizer/prep/prepkeyset.c		diff \| blob \| history
src/backend/optimizer/prep/prepunion.c		diff \| blob \| history
src/backend/optimizer/util/Makefile		diff \| blob \| history
src/backend/optimizer/util/clauses.c		diff \| blob \| history
src/backend/optimizer/util/indexnode.c	[deleted file]	blob \| history
src/backend/optimizer/util/pathnode.c		diff \| blob \| history
src/backend/optimizer/util/plancat.c		diff \| blob \| history
src/backend/optimizer/util/relnode.c		diff \| blob \| history
src/backend/optimizer/util/restrictinfo.c		diff \| blob \| history
src/backend/parser/analyze.c		diff \| blob \| history
src/backend/parser/gram.y		diff \| blob \| history
src/backend/parser/parse_agg.c		diff \| blob \| history
src/backend/parser/parse_clause.c		diff \| blob \| history
src/backend/parser/parse_expr.c		diff \| blob \| history
src/backend/parser/parse_func.c		diff \| blob \| history
src/backend/parser/parse_node.c		diff \| blob \| history
src/backend/parser/parse_relation.c		diff \| blob \| history
src/backend/parser/parse_target.c		diff \| blob \| history
src/backend/rewrite/Makefile		diff \| blob \| history
src/backend/rewrite/locks.c	[deleted file]	blob \| history
src/backend/rewrite/rewriteDefine.c		diff \| blob \| history
src/backend/rewrite/rewriteHandler.c		diff \| blob \| history
src/backend/rewrite/rewriteManip.c		diff \| blob \| history
src/backend/rewrite/rewriteRemove.c		diff \| blob \| history
src/backend/rewrite/rewriteSupport.c		diff \| blob \| history
src/backend/utils/adt/ruleutils.c		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/executor/nodeSubqueryscan.h	[new file with mode: 0644]	blob
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/nodes/nodes.h		diff \| blob \| history
src/include/nodes/parsenodes.h		diff \| blob \| history
src/include/nodes/pg_list.h		diff \| blob \| history
src/include/nodes/plannodes.h		diff \| blob \| history
src/include/nodes/primnodes.h		diff \| blob \| history
src/include/nodes/relation.h		diff \| blob \| history
src/include/optimizer/clauses.h		diff \| blob \| history
src/include/optimizer/pathnode.h		diff \| blob \| history
src/include/optimizer/paths.h		diff \| blob \| history
src/include/optimizer/plancat.h		diff \| blob \| history
src/include/optimizer/planmain.h		diff \| blob \| history
src/include/parser/parse_agg.h		diff \| blob \| history
src/include/parser/parse_node.h		diff \| blob \| history
src/include/parser/parse_relation.h		diff \| blob \| history
src/include/rewrite/locks.h	[deleted file]	blob \| history
src/include/rewrite/rewriteManip.h		diff \| blob \| history
src/include/rewrite/rewriteSupport.h		diff \| blob \| history
src/test/regress/expected/errors.out		diff \| blob \| history

PostgreSQL9.0用の同期レプリケーションパッチ

RSS Atom

About OSDN

Find Software

Develop Software

Help