Re: plpgsql/rule question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql/rule question
Date: 2005-01-12 03:58:57
Message-ID: 6751.1105502337@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-12 04:02:23 Re: plpgsql/rule question
Previous Message Ed L. 2005-01-12 03:53:54 Re: plpgsql/rule question