Re: still problem: inserting into writeable views - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: still problem: inserting into writeable views
Date
Msg-id 493215D8.7060200@opencloud.com
Whole thread Raw
In response to Re: still problem: inserting into writeable views  (Oliver Jowett <oliver@opencloud.com>)
List 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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: still problem: inserting into writeable views
Next
From: Bruce Hyatt
Date:
Subject: Connect via odbc from Windows to Linux