OSDN Git Service

ALTER TABLE DROP COLUMN works. Patch by Christopher Kings-Lynne,
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 2 Aug 2002 18:15:10 +0000 (18:15 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 2 Aug 2002 18:15:10 +0000 (18:15 +0000)
commit38bb77a5d15aa022248488bc8c0147139ce120a9
treed01573bceae2db61eb97421f91c6068ef8522b66
parent5e6528adf726429463a5c1f3edf712f98d6b5f7e
ALTER TABLE DROP COLUMN works.  Patch by Christopher Kings-Lynne,
code review by Tom Lane.  Remaining issues: functions that take or
return tuple types are likely to break if one drops (or adds!)
a column in the table defining the type.  Need to think about what
to do here.

Along the way: some code review for recent COPY changes; mark system
columns attnotnull = true where appropriate, per discussion a month ago.
44 files changed:
contrib/dblink/dblink.c
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/alter_table.sgml
doc/src/sgml/ref/copy.sgml
doc/src/sgml/release.sgml
src/backend/access/common/tupdesc.c
src/backend/bootstrap/bootstrap.c
src/backend/catalog/dependency.c
src/backend/catalog/heap.c
src/backend/catalog/pg_proc.c
src/backend/commands/analyze.c
src/backend/commands/comment.c
src/backend/commands/copy.c
src/backend/commands/indexcmds.c
src/backend/commands/tablecmds.c
src/backend/optimizer/prep/preptlist.c
src/backend/optimizer/prep/prepunion.c
src/backend/parser/analyze.c
src/backend/parser/parse_func.c
src/backend/parser/parse_relation.c
src/backend/parser/parse_target.c
src/backend/parser/parse_type.c
src/backend/rewrite/rewriteDefine.c
src/backend/rewrite/rewriteHandler.c
src/backend/utils/adt/not_in.c
src/backend/utils/cache/lsyscache.c
src/backend/utils/cache/syscache.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dump.h
src/bin/psql/describe.c
src/bin/psql/tab-complete.c
src/include/catalog/catversion.h
src/include/catalog/heap.h
src/include/catalog/pg_attribute.h
src/include/catalog/pg_class.h
src/include/executor/executor.h
src/include/parser/parse_relation.h
src/include/utils/lsyscache.h
src/include/utils/syscache.h
src/pl/plpgsql/src/pl_comp.c
src/test/regress/expected/alter_table.out
src/test/regress/expected/copy2.out
src/test/regress/sql/alter_table.sql
src/test/regress/sql/copy2.sql