On Tuesday January 11 2005 8:58, Tom Lane wrote:
> "Ed L." <pgsql@xxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
