On Tuesday January 11 2005 8:58, Tom Lane wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > The reason I ask is because I'd like to allow any explicitly specified
> > values for the view insert, including NULL, to be passed through to the
> > table insert and override the column defaults.
>
> Possibly you can solve your problem by attaching the defaults to the
> view, not to the table at all. ALTER TABLE view ALTER COLUMN col SET
> DEFAULT something has worked for a number of PG releases...
Perfect, thanks. The more I learn, the less I know.
Ed