Re: [GENERAL] client that supports editing views

2014-02-10 Thread Wolfgang Keller
> This is now my ranked shortlist which I will evaluate further: > 1. Camelot: http://www.python-camelot.com - PyQt > 2. Dabo: http://www.dabodev.com - wxPython > 3. Gui2Py: http://code.google.com/p/gui2py/ - wxPython > 4. Kiwi: http://www.async.com.br/projects/kiwi - PyGTK > 5. Sqlkit: http://sqlk

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Stefan Keller
Hi Wolfgang Thanks! This is now my ranked shortlist which I will evaluate further: 1. Camelot: http://www.python-camelot.com - PyQt 2. Dabo: http://www.dabodev.com - wxPython 3. Gui2Py: http://code.google.com/p/gui2py/ - wxPython 4. Kiwi: http://www.async.com.br/projects/kiwi - PyGTK 5. Sqlkit: h

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Wolfgang Keller
> Q1 => Can anybody recommend a >> desktop GUI tool (preferrably open > source) << for PG with customizable forms like Access or FileMaker? Without programming: - LO/OO Base: www.libreoffice.org, www.openoffice.org - Kexi: www.kexi-project.org - Rekall is apparently dead, unfortunately. Using P

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Adrian Klaver
On 02/08/2014 05:24 AM, Stefan Keller wrote: Hi Thomas and Alexandros Thanks for your quick replies! If possible I'd prefer an open source framework. I've actually found another possible solution candidate: Using Qt Designer [1]. I'm still evaluation and now keen if anybody stands up to vote for

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Stefan Keller
Hi Thomas and Alexandros Thanks for your quick replies! If possible I'd prefer an open source framework. I've actually found another possible solution candidate: Using Qt Designer [1]. I'm still evaluation and now keen if anybody stands up to vote for a pgAdmin plugin...? -- Stefan [1] "Postmode

Re: [GENERAL] client that supports editing views

2014-02-08 Thread alexandros_e
Why not use Access directly? You can connect to PostgreSQL though ODBC (inside Access) and do the forms there. I am sure 95% that I had done that in the past, although I cannot be sure it works with the most recent versions. Something like that: http://www.depts.ttu.edu/ithelpcentral/solutions/od

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Thomas Kellerer
Stefan Keller wrote on 08.02.2014 12:31: If pgAdmin is acceptable, you might want to try SQL Workbench/J: http://www.sql-workbench.net I'd like to revive that discussion and like to know: Q1 => Can anybody recommend a >> desktop GUI tool (preferrably open source) << for PG with customizable for

Re: [GENERAL] client that supports editing views

2014-02-08 Thread Stefan Keller
Hi, 2013-12-09 Thomas Kellerer : > Willy-Bas Loos wrote on 09.12.2013 21:44: >> I've tried: >> * pgAdmin >> * MS Access 2010 over ODBC >> * LibreOffice.org with the SDBC driver. ... > If pgAdmin is acceptable, you might want to try SQL Workbench/J: > http://www.sql-workbench.net I'd like to reviv

Re: [GENERAL] client that supports editing views

2013-12-10 Thread Richard Broersma
On Mon, Dec 9, 2013 at 7:16 AM, Adrian Klaver wrote: > Is there a timestamp field in the view? This sounds like an issue Access > has with timestamp precision, where if you supply a timestamp that is too > precise it has problems. See here for more detail: > Updateable view can be a challenge du

Re: [GENERAL] client that supports editing views

2013-12-10 Thread Thomas Kellerer
Willy-Bas Loos, 10.12.2013 13:30: > cool, SQL Workbench/J: does the job. > It's too bad that it doesn't list the lables/views, so that you can't just > open them with a click > (i use select * from table to get the data), but it works well. > Did you check the "Database Explorer"? http://www.s

Re: [GENERAL] client that supports editing views

2013-12-10 Thread Willy-Bas Loos
cool, SQL Workbench/J: does the job. It's too bad that it doesn't list the lables/views, so that you can't just open them with a click (i use select * from table to get the data), but it works well. thanks Thomas. On Mon, Dec 9, 2013 at 11:51 PM, Thomas Kellerer wrote: > Willy-Bas Loos wrote o

Re: [GENERAL] client that supports editing views

2013-12-09 Thread Thomas Kellerer
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 ve

Re: [GENERAL] client that supports editing views

2013-12-09 Thread Willy-Bas Loos
No, there's no timestamp. Here's a screenshot of the error in access 2010. I'll have tot translate it, it's in dutch (and you can't change the language like you can in ubuntu.. ) It says: ==write conflict== As you were editing the record, it was changed by another user. If you save the record, the

Re: [GENERAL] client that supports editing views

2013-12-09 Thread Adrian Klaver
On 12/09/2013 05:36 AM, Willy-Bas Loos wrote: I have a database with views that have rules on them, so that users can do insert/update/delete on their part of the data. The rules ore "do instead" rules that redirect the edits to the table that actually holds the data, on which the users have no r

Re: [GENERAL] client that supports editing views

2013-12-09 Thread Thomas Kellerer
Willy-Bas Loos, 09.12.2013 14:36: > I have a database with views that have rules on them, so that users > can do insert/update/delete on their part of the data. The rules ore > "do instead" rules that redirect the edits to the table that actually > holds the data, on which the users have no rights.

[GENERAL] client that supports editing views

2013-12-09 Thread Willy-Bas Loos
I have a database with views that have rules on them, so that users can do insert/update/delete on their part of the data. The rules ore "do instead" rules that redirect the edits to the table that actually holds the data, on which the users have no rights. This works fine in MS Access (at least v