Re: [GENERAL] query syntax to combine 2 set returning functions ?

2013-03-03 Thread Marc Mamin
> I can't find the syntax to get the results in multiple columns instaed of a > singel 'record' column: > select  get_table_depends('cicpg_logs', t) FROM get_modeltablelist('efeeds') > t I got it: select (get_table_depends('cicpg_logs', t)).* FROM get_modeltablelist('efeeds') t ^

Re: [HACKERS] [GENERAL] Floating point error

2013-03-03 Thread Tom Lane
Maciek Sakrejda writes: > [ a bunch of questions that boil down to: ] > Isn't full fidelity possible assuming sensible rounding semantics and > enough characters of precision? The fundamental issue is that the underlying representation is binary and so its precision limit doesn't correspond to an

Re: [HACKERS] [GENERAL] Floating point error

2013-03-03 Thread Maciek Sakrejda
While having more docs around extra_float_digits is a great idea, I don't think the patch really clarifies much. (Disclaimer: I honestly have only a vague idea of the reasoning behind extra_float_digits existing in the first place, but perhaps that means I'm a good target audience for the doc patc

Fwd: [GENERAL] pg_upgrade

2013-03-03 Thread Ian Harding
Ack! Sorry. Bad list etiquette in so many ways... -- Forwarded message -- From: Ian Harding Date: Sun, Mar 3, 2013 at 8:26 PM Subject: Re: [GENERAL] pg_upgrade To: Bruce Momjian It doesn't seem to though. Here's what I get when I leave it alone (no changes to postgresql.conf

[GENERAL] out of memory issue

2013-03-03 Thread G N
Hello Friends, Hope you are all well... I have a specific issue, where my query fails with below error while trying to export data from pgadmin SQL tool. There are no such issues when the result set is small. But it returns error when the result set is bit large. Any inputs please ? Where and

Re: [GENERAL] Scalable cluster

2013-03-03 Thread Gregg Jaskiewicz
On 3 March 2013 22:56, John R Pierce wrote: > > did you look at pgbouncer ? thats the simple pooler for postgres, and its > quite robust, because its so simple. > > Yes, it is one of the solutions I do consider. Having applications decide whether they should write to master, or use slaves and/or

Re: [GENERAL] Scalable cluster

2013-03-03 Thread John R Pierce
On 3/3/2013 1:57 PM, Gregg Jaskiewicz wrote: I don't know of any other pooling solution that would be capable of handling the job, but focus only on the task of pooling (pgpool's fault probably is that it is trying to be jack of all trades) in HA replicated scenario. did you look at pgbounc

[GENERAL] Scalable cluster

2013-03-03 Thread Gregg Jaskiewicz
Hi guys, I'm looking into setting up an HA scalable DB cluster. So far my tests with streaming replication proof that it is very very good indeed. However, problem seems to be on the connection pooling side. Ideally, we would love to have single point of connection to the cluster, but I do realis