Re: updateable resultset only working for tables?

Поиск
Список
Период
Сортировка
От Guido Fiala
Тема Re: updateable resultset only working for tables?
Дата
Msg-id 200403111605.34910.guido.fiala@dka-gmbh.de
обсуждение исходный текст
Ответ на Re: updateable resultset only working for tables?  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Views are updateable with RULES only...

However, maybe i went the completly the wrong way choosing views for this
problem:

I want that certain groups can only update/select certain columns in tables,
and that's what views are for.

Thanks, for your help.
Guido

Am Donnerstag, 11. März 2004 15:29 schrieb Dave Cramer:
> Sorry Guido, I misunderstood, I thought you wanted a updateable
> statement on a table without a primary key.
>
> views in postgres are not updateable... so until that is done you are
> unfortunately beat.
>
> The updateable result set interface specifies that only simple result
> sets are updateable, and "simple" varies from db to db.
>
> Dave
>


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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: updateable resultset only working for tables?
Следующее
От: Barry Lind
Дата:
Сообщение: Re: updateable resultset only working for tables?