Re: inserting to a multi-table view - Mailing list pgsql-general

From Richard Broersma
Subject Re: inserting to a multi-table view
Date
Msg-id 396486430806171246h2f644057o6e9ff2c9954ed4db@mail.gmail.com
Whole thread Raw
In response to Re: inserting to a multi-table view  ("Michael Shulman" <shulman@mathcamp.org>)
List pgsql-general
On Tue, Jun 17, 2008 at 12:34 PM, Michael Shulman <shulman@mathcamp.org> wrote:
> Would it be possible to actually do something like this in an update
> rule?  You couldn't write the "begin/commit", but it seems that you
> wouldn't need to either, since the UPDATE command invoking the rule
> will be wrapped in its own begin/commit (automatic or explicit).

Thats a good question. I've never tried it. and since then, I gotten
away from using update-able view.  In my case, I like using Natural
Primary keys so update-able views wouldn't work for me any more. :o)


--
Regards,
Richard Broersma Jr.

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

pgsql-general by date:

Previous
From: "Michael Shulman"
Date:
Subject: Re: inserting to a multi-table view
Next
From: Garry Saddington
Date:
Subject: UTF8 encoding problem