default values for views - Mailing list pgsql-patches

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.

Cheers,

Neil

--
Neil Conway <[email protected]>
PGP Key ID: DB3C29FC

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ANSI Compliant Inserts
Next
From: Tom Lane
Date:
Subject: Re: default values for views