Re: Thoughts about updateable views

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: Thoughts about updateable views
Дата
Msg-id Pine.LNX.4.58.0403230806200.8068@linuxworld.com.au
обсуждение исходный текст
Ответ на Thoughts about updateable views  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: Thoughts about updateable views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 22 Mar 2004, Bernd Helmle wrote:

> I am currently thinking of updateable views for a possible student research
> project. In this
> case there comes some points to my mind, i want to share with the list.
>
> a) Definition of an updateable view?

The SQL spec. You should definately get a look at at least the SQL92
definition before proceeding.

> b) The creation of an automatic INSERT/UPDATE or DELETE Rule had to be done
> with
> the creation of the SELECT Rule. I understand how PostgreSQL handles views
> with its Rule
> System, but what happens when no appropiate Rule can be created? Reject the

CREATE VIEW needs to check if all columns in the target list and the base
table are updatable or insertable into. Eg: How can you update: select
foo, random() from bar?

If the user specifically asked for an updatable view, then they can't have
one. If they didn't specifically ask, they get the usual read only view.

Gavin


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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Thoughts about updateable views
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: pg_autovacuum next steps