Re: updateable resultset only working for tables? - Mailing list pgsql-jdbc

From Guido Fiala
Subject Re: updateable resultset only working for tables?
Date
Msg-id 200403111605.34910.guido.fiala@dka-gmbh.de
Whole thread Raw
In response to Re: updateable resultset only working for tables?  (Dave Cramer <pg@fastcrypt.com>)
List 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 by date:

Previous
From: Dave Cramer
Date:
Subject: Re: updateable resultset only working for tables?
Next
From: Barry Lind
Date:
Subject: Re: updateable resultset only working for tables?