| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2004-03-11 17:03:14 | Re: updateable resultset only working for tables? |
| Previous Message | Dave Cramer | 2004-03-11 14:29:13 | Re: updateable resultset only working for tables? |