Re: INSERT/UPDATE/DELETE Views

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: INSERT/UPDATE/DELETE Views
Дата
Msg-id 3ECA4A0F.2040402@Yahoo.com
обсуждение исходный текст
Ответ на INSERT/UPDATE/DELETE Views  (Kaarel <kaarel@future.ee>)
Список 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@Yahoo.com #


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: INSERT/UPDATE/DELETE Views
Следующее
От: "Ben Joyce"
Дата:
Сообщение: pg newbie stumped on sequences!