Re: Updatable view does not work [oops, quite long!]

Поиск
Список
Период
Сортировка
От Thiemo Kellner
Тема Re: Updatable view does not work [oops, quite long!]
Дата
Msg-id 3EDEF94B.5060306@thiam.ch
обсуждение исходный текст
Ответ на Re: Updatable view does not work [oops, quite long!]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
> Not very surprising, since "WHERE foo = bar" cannot succeed if either
> foo or bar is null.

This confirms my suspicion.

> You should not be comparing every field of the rows anyway.  You should
> make sure that pwd has a primary key (which by definition must be
> non-null) and then check only the primary key field or fields in the
> rule WHERE clauses.

Well this was a futile attempt to hide the primary key pwd_id on the
base table from the end user.

Thanks,

Thiemo

--
root ist die Wurzel allen Übels


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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Updatable view does not work [oops, quite long!]
Следующее
От: "Theuns"
Дата:
Сообщение: IpcMemoryCreate: shmget failed (Permission denied)