Alter Table phase 1 -- Please apply to 7.5

From: Rod Taylor <pg(at)rbt(dot)ca>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Alter Table phase 1 -- Please apply to 7.5
Date: 2003-11-16 21:58:43
Message-ID: 1069019922.21552.75.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Completes:
ALTER TABLE ADD COLUMN does not honour DEFAULT and non-CHECK
CONSTRAINT

ALTER TABLE ADD COLUMN column DEFAULT should fill existing rows
with DEFAULT value

ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence
because of the item above

Previously described reorganization of all ALTER TABLE commands.

Most of the way through column type change. I need to supply a followup
patch which deals with logical attribute numbers.

ALTER TABLE table ALTER [COLUMN] column TYPE type USING expression;

Syntax documentation updates only. Content to come later.

Attachment Content-Type Size
altertable.patch.gz application/x-gzip 37.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-11-16 22:46:17 Re: [PATCHES] SRA Win32 sync() code
Previous Message Jan Wieck 2003-11-16 20:43:27 Re: [PATCHES] SRA Win32 sync() code