Willy-Bas Loos wrote on 09.12.2013 21:44:
But the option to save the record is disabled, the other 2 buttons do not
enable me to save the record.
Anyway, i don't care much for MS Access, any client will do (that is, if it
costs money,
it would be nice if most users own it already or it isn't very expensive)
I've tried:
* pgAdmin
* MS Access 2010 over ODBC
* LibreOffice.org with the SDBC driver.
Does anyone know of a client that is either smart enough to understand about
rules on views,
or transparent enough to let the server handle everything?
If pgAdmin is acceptable, you might want to try SQL Workbench/J:
http://www.sql-workbench.net
It will allow to run inserts on anything that you can select from and it will
prompt the user for the PK columns in case none could be identified in the
database (such as when updating the result of a select based on a view or
retrieving data from a table without a PK). The selection of the PK columns can
be saved (locally) to avoid further prompting
Disclosure: I am the author of that tool.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
