1. 05 May, 2004 1 commit
    • Tom Lane's avatar
      ALTER TABLE rewrite. New cool stuff: · 077db40f
      Tom Lane authored
      * 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.
      077db40f
  2. 03 May, 2004 2 commits
  3. 02 May, 2004 9 commits
  4. 01 May, 2004 5 commits
  5. 30 Apr, 2004 14 commits
  6. 29 Apr, 2004 2 commits
  7. 28 Apr, 2004 1 commit
    • Bruce Momjian's avatar
      Fix typo: · a3b0c90e
      Bruce Momjian authored
      <   columns and indexes with many duplicate keys
      a3b0c90e
  8. 27 Apr, 2004 6 commits