Re: [SQL] Using rules to implement backward-compatible schema changes

2007-12-31 Thread Mario Becroft
Tom Lane <[EMAIL PROTECTED]> writes: > Mario Becroft <[EMAIL PROTECTED]> writes: >> The problem is that when inserting to the view, default values do not >> work as expected. > > You need to attach the defaults to the view, viz > > ALTER TABLE a ALTER COLUMN bar SET DEFAULT 5; > > This is co

Re: [SQL] Using rules to implement backward-compatible schema changes

2007-12-31 Thread Tom Lane
Mario Becroft <[EMAIL PROTECTED]> writes: > The problem is that when inserting to the view, default values do not > work as expected. You need to attach the defaults to the view, viz ALTER TABLE a ALTER COLUMN bar SET DEFAULT 5; This is considered a feature not a bug, since you might wan