Re: INSERT/UPDATE/DELETE Views

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
Cc: Kaarel <kaarel(at)future(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT/UPDATE/DELETE Views
Date: 2003-05-20 15:30:23
Message-ID: 3ECA4A0F.2040402@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darko Prenosil wrote:
> On Tuesday 20 May 2003 12:01, Kaarel wrote:
>
>>Hi
>>
>>I'm relatively new to PostgreSQL. I was wondering why were
>>INSERT/UPDATE/DELETE view diabled in PostgreSQL? Other database systems
>>have these features so why shouldn't PostgreSQL. I did some searching
>>and found that prior version 7.1 or 7.0 these features were in fact
>>enabled. I couldn't however find a satisfying reason for the removal of
>>these features from PostqreSQL mailing list archives.
>>
>>
>
> Postgres had, and still have update, delete and insert rules, which can be
> used to "simulate" updatable views. Read documentation ! You can start with
> "CREATE RULE" sql command. It is too much to explain it in one mail.

That "documentation" would be

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=rules.html

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Joyce 2003-05-20 16:13:20 pg newbie stumped on sequences!
Previous Message Tom Lane 2003-05-20 15:25:24 Re: INSERT/UPDATE/DELETE Views