Re: [GENERAL] password-less access, without using pg_hba

On Fri, Feb 7, 2014 at 8:27 AM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > Ignoring the scary security issues > One of the niceties of an RDS deployment is that I don't care much about the security issues: The machine is not in our VPC, there's only public data on it, and I pre

Re: [GENERAL] Dynamic insert into ARRAY? plpgsql

George Ant wrote > Thank you for your Response! > > Inserting a sub-select into the array seems to be the solution that I > want, but it gives me this error--> subquery must return only one column > > Any help? > > Kind Regards, > George Ant In both cases you want to be storing a single compo

Re: [GENERAL] client that supports editing views

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] Dynamic insert into ARRAY? plpgsql

Thank you for your Response! Inserting a sub-select into the array seems to be the solution that I want, but it gives me this error--> subquery must return only one column Any help? Kind Regards, George Ant -- View this message in context: http://postgresql.1045698.n5.nabble.com/Dynamic-in

Re: [GENERAL] PL/pgSQL Copy data from one table to another

George Ant wrote > Hey Guys, > > Thank you for your replies! Your suggestions worked fine!! :) Also my code > looks a lot cleaner now! > > Kind Regards, > George Ant. Have you considered just creating a view, or even retrieval functions, the generate these "object forms" on the fly instead of

Re: [GENERAL] Dynamic insert into ARRAY? plpgsql

alexandros_e wrote > You must a) join the 2 tables on the orderID ... where orderID=15 and then > GROUP BY the result by the order ID and concat the orderlines by a custom > aggregate function like: > http://www.postgresql.org/message-id/db7789b.0309131210.625da...@posting.google.com Maybe back in

Re: [GENERAL] Dynamic insert into ARRAY? plpgsql

You must a) join the 2 tables on the orderID ... where orderID=15 and then GROUP BY the result by the order ID and concat the orderlines by a custom aggregate function like: http://www.postgresql.org/message-id/db7789b.0309131210.625da...@posting.google.com -- View this message in context: ht

Re: [GENERAL] Dynamic insert into ARRAY? plpgsql

George Ant wrote > Hey Guys, > > I have a table(Orders_object_table) of this type: > > CREATE TYPE orders_type AS >(orderid integer, > amount amount_type, > customerid integer, > orderdate date, > orderlines orderlines_type[]); > > and I am trying to insert data from anothe

[GENERAL] Dynamic insert into ARRAY? plpgsql

Hey Guys, I have a table(Orders_object_table) of this type: CREATE TYPE orders_type AS (orderid integer, amount amount_type, customerid integer, orderdate date, orderlines orderlines_type[]); and I am trying to insert data from another tables(Orders and Orderlines). Each Or

Re: [GENERAL] PL/pgSQL Copy data from one table to another

Hey Guys, Thank you for your replies! Your suggestions worked fine!! :) Also my code looks a lot cleaner now! Kind Regards, George Ant. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PL-pgSQL-Copy-data-from-one-table-to-another-tp5790663p5791086.html Sent from the

Re: [GENERAL] client that supports editing views

> 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] Better Connection Statistics

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > For instance, I want the number of transactions a specific connection has > submitted. > The number of queries. Total amount of CPU time consumed, etc. So far as I > know, > there is no module, statistic, or view that provides any of this.

Re: [GENERAL] client that supports editing views

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

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

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

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

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