Hi everybody,
I know this has been written about before, but no solution has been
given. Writing (insert, update, delete) to a view is generally not
possible in PostgreSQL. But if rules have been set up to redirect write
access to a view to some other (real) table, it works fine. Even using
Squirrel SQL, which has been written in Java and uses
org.postgresql.Driver, can write to writeable views.
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?
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Germany
Telefon (0 22 02) 81 71 57, mobil (01 78) 9 75 90 12
Mails sollte man signieren und nach Möglichkeit verschlüsseln
siehe http://www.gnupg.org/gph/de/manual/f20.html