View and primary key

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема View and primary key
Дата
Msg-id 200211220551.16547.aklaver@attbi.com
обсуждение исходный текст
Ответы Re: View and primary key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I have set up a view with rules for insert,update and delete. I would like to
be able to use this view from OpenOffice, however it will not allow editing
of a table without a primary key. I cannot create a primary key because
Postgresql says the column does not have a NOT NULL constraint. This column
in the underlying table is NOT NULL. Is there a way to create a primary key
on a view?

                                   Thank you
                                    Adrian Klaver

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: how do i find out when a record was created/modified?
Следующее
От: Felipe Schnack
Дата:
Сообщение: EXECUTE problems