Re: still problem: inserting into writeable views

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Holger Jakobs <Holger(at)Jakobs(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: still problem: inserting into writeable views
Date: 2008-11-30 04:26:00
Message-ID: 493215D8.7060200@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Oliver Jowett wrote:
> Holger Jakobs wrote:
>
>> Using JDBC (org.postgresql.Driver) produces an error
>> org.postgresql.util.PSQLException: FEHLER: kann nicht in eine Sicht
>> einfügen
>> (German version, translates as 'ERROR: cannot insert into a view')
>>
>> Why can't the JDBC driver just leave the decision whether a table/view
>> is writeable or not to the database instead of interfering?
>
> I don't see that error message in the JDBC driver's de.po, and there's
> no equivalent check or message in the driver that I can see. Are you
> sure the error is generated by the driver and not by the backend?

I just checked the server's de.po and this is almost certainly a
backend-generated error, not a driver-generated error.
src/backend/po/de.po has:

#: rewrite/rewriteHandler.c:1811
msgid "cannot insert into a view"
msgstr "kann nicht in eine Sicht einfügen"

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Hyatt 2008-12-01 03:18:55 Connect via odbc from Windows to Linux
Previous Message Oliver Jowett 2008-11-30 04:08:31 Re: still problem: inserting into writeable views