Re: plpgsql/rule question - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql/rule question
Date
Msg-id 6751.1105502337@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql/rule question  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: plpgsql/rule question
List pgsql-general
"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...

            regards, tom lane

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: plpgsql/rule question
Next
From: Michael Fuhr
Date:
Subject: Re: plpgsql/rule question