Skip site navigation (1) Skip section navigation (2)

Re: updateable resultset only working for tables?

From: Guido Fiala <guido(dot)fiala(at)dka-gmbh(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: updateable resultset only working for tables?
Date: 2004-03-11 15:05:34
Message-ID: 200403111605.34910.guido.fiala@dka-gmbh.de (view raw or flat)
Thread:
Lists: 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
>


In response to

pgsql-jdbc by date

Next:From: Barry LindDate: 2004-03-11 17:03:14
Subject: Re: updateable resultset only working for tables?
Previous:From: Dave CramerDate: 2004-03-11 14:29:13
Subject: Re: updateable resultset only working for tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group