Search Postgresql Archives

Re: plpgsql/rule question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"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...

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux