Re: Updatable Views - DEFAULT doesn't inherit from table???

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: Csaba Együd <csegyud(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Updatable Views - DEFAULT doesn't inherit from table???
Date: 2008-12-05 14:56:27
Message-ID: 396486430812050656n25618697l6bcb091d0fcf4f78@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/12/5 Richard Huxton <dev(at)archonet(dot)com>:

> I can't recall if you do ALTER VIEW view_products_1 or ALTER
> TABLE view_products_1, but it's one of them.

It seems odd, but adding defaults to a VIEW is done with ALTER TABLE.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MatT 2008-12-05 15:05:45 tuples
Previous Message Grzegorz Jaśkiewicz 2008-12-05 14:42:32 Re: Updatable Views - DEFAULT doesn't inherit from table???