Re: inserting to a multi-table view

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Michael Shulman" <shulman(at)mathcamp(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: inserting to a multi-table view
Date: 2008-06-17 19:46:27
Message-ID: 396486430806171246h2f644057o6e9ff2c9954ed4db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 17, 2008 at 12:34 PM, Michael Shulman <shulman(at)mathcamp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2008-06-17 21:33:40 Re: PostgreSQL and AMD?
Previous Message Michael Shulman 2008-06-17 19:34:55 Re: inserting to a multi-table view