Skip site navigation (1) Skip section navigation (2)

pgsql-server/ oc/src/sgml/ref/alter_table.sgml ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ oc/src/sgml/ref/alter_table.sgml ...
Date: 2004-05-05 04:48:48
Message-ID: 20040505044848.6DF11D1E5FB@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)svr1(dot)postgresql(dot)org	04/05/05 01:48:48

Modified files:
	doc/src/sgml/ref: alter_table.sgml 
	src/backend/bootstrap: bootparse.y 
	src/backend/catalog: dependency.c heap.c index.c 
	src/backend/commands: cluster.c indexcmds.c tablecmds.c 
	src/backend/nodes: copyfuncs.c equalfuncs.c 
	src/backend/parser: analyze.c gram.y 
	src/backend/tcop: utility.c 
	src/backend/utils/adt: ruleutils.c 
	src/include/catalog: dependency.h heap.h index.h 
	src/include/commands: cluster.h defrem.h tablecmds.h 
	src/include/nodes: nodes.h parsenodes.h 
	src/include/parser: analyze.h 
	src/include/utils: builtins.h 
	src/test/regress/expected: alter_table.out foreign_key.out 
	                           inherit.out 
	src/test/regress/sql: alter_table.sql foreign_key.sql 
	                      inherit.sql 

Log message:
	ALTER TABLE rewrite.  New cool stuff:
	
	* ALTER ... ADD COLUMN with defaults and NOT NULL constraints works per SQL
	spec.  A default is implemented by rewriting the table with the new value
	stored in each row.
	
	* ALTER COLUMN TYPE.  You can change a column's datatype to anything you
	want, so long as you can specify how to convert the old value.  Rewrites
	the table.  (Possible future improvement: optimize no-op conversions such
	as varchar(N) to varchar(N+1).)
	
	* Multiple ALTER actions in a single ALTER TABLE command.  You can perform
	any number of column additions, type changes, and constraint additions with
	only one pass over the table contents.
	
	Basic documentation provided in ALTER TABLE ref page, but some more docs
	work is needed.
	
	Original patch from Rod Taylor, additional work from Tom Lane.


Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2004-05-05 04:49:10
Subject: Re: Multiple Xids in PGPROC?
Previous:From: Christopher Kings-LynneDate: 2004-05-05 04:45:45
Subject: Re: Multiple Xids in PGPROC?

pgsql-committers by date

Next:From: Christopher Kings-LynneDate: 2004-05-05 05:27:09
Subject: Re: pgsql-server/ oc/src/sgml/ref/alter_table.sgml ...
Previous:From: Bruce MomjianDate: 2004-05-03 13:25:23
Subject: pgsql-server/src/test/regress pg_regress.sh

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group