Skip site navigation (1) Skip section navigation (2)

default values for views

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: default values for views
Date: 2002-04-15 22:19:43
Message-ID: 20020415181943.25bdf9e2.nconway@klamath.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-patches
The attached patch allows views to have default values. You can't
specify a default value within a CREATE VIEW statement, it must be
done using ALTER TABLE ... ALTER COLUMN ... SET DEFAULT after the
view has already been created. Most of the hard work was done by
Tom Lane, I just patched pg_dump and updated the documentation.

Cheers,

Neil

-- 
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

Attachment: rule_default_value-2.patch
Description: application/octet-stream (4.2 KB)

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2002-04-15 22:24:43
Subject: Re: default values for views
Previous:From: Dmitry TkachDate: 2002-04-15 22:10:11
Subject: Re: Alter/update large tables - VERRRY annoying behaviour!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group