Skip to content
Snippets Groups Projects
  • Bruce Momjian's avatar
    19b31e07
    Oops, wrong commit on previous. It was: · 19b31e07
    Bruce Momjian authored
    The attached patch allows views to have default values. You can't
    specify a default value within a CREATE VIEW statement, it must be
    done using ALTER TABLE ... ALTER COLUMN ... SET DEFAULT after the
    view has already been created. Most of the hard work was done by
    Tom Lane, I just patched pg_dump and updated the documentation.
    
    Neil Conway <neilconway@rogers.com>
    19b31e07
    History
    Oops, wrong commit on previous. It was:
    Bruce Momjian authored
    The attached patch allows views to have default values. You can't
    specify a default value within a CREATE VIEW statement, it must be
    done using ALTER TABLE ... ALTER COLUMN ... SET DEFAULT after the
    view has already been created. Most of the hard work was done by
    Tom Lane, I just patched pg_dump and updated the documentation.
    
    Neil Conway <neilconway@rogers.com>