From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: Updatable Views |
Date: | 2007-11-27 20:04:52 |
Message-ID: | Pine.LNX.4.64.0711271204160.366@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
On Tue, 27 Nov 2007, Jeff Davis wrote:
> PostgreSQL supports updatable views through a more generalized mechanism
> called rules. You actually have more flexibility with rules, and can make
> some views updatable that you can't in other databases.
> Another benefit is that PostgreSQL has transactional DDL, meaning that you
> can replace a table by an updatable view within a transaction, so that
> there's no window of time in which the table is inconsistent or
> nonexistent.
Thanks very much, Jeff. That's very helpful.
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2007-11-28 05:01:18 | Re: Updatable Views |
Previous Message | Jeff Davis | 2007-11-27 19:55:21 | Re: Updatable Views |