Le dimanche 03 mars 2013 à 23:29 +, Gregg Jaskiewicz a écrit :
>
>
> I wonder however, how others are handing it. There seems to be nothing
> out there apart from pgbouncer and pgpool. And only the latter can
> handle (albeit not really that quick) pooling between master and
> slaves.
>
>
On Mon, Mar 4, 2013 at 1:24 AM, Marc Mamin wrote:
>> 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_l
On Sun, Mar 3, 2013 at 11:05 AM, G N wrote:
> 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
On 4 Mar 2013, at 13:21, Vincent Veyron wrote:
>
> There is this :
>
> http://wiki.postgresql.org/wiki/Postgres-XC
>
>
> [Disclaimer : I can't tell whether it's usable or not; I just know they
> exist]
>
Well, I know of its existence too. Question is how production ready is it. And
also
Version 1.1 will be out in this June time frame, with online node
addition/removal, Trigger and improved planner. I'm more than happy
if you evaluate XC.
Regards;
--
Koichi Suzuki
2013/3/4 Greg Jaskiewicz :
>
> On 4 Mar 2013, at 13:21, Vincent Veyron wrote:
>
>>
>> There is this :
>>
>
One question about Postgres-XC, can it distribute one single query in
all nodes ?
Example,
Nodes: Node1,Node2,Node3
Query:"SELECT sum(foo) FROM bar group by foo"
(Obvious: Your data has to be shared between the nodes)
Query -> Compiler (in the pool)-> "share the query between the nodes"
-> merge
just fixing:
like Netezza which has full implementation to do it.*
On 4 March 2013 14:59, Daniel de Oliveira Mantovani
wrote:
> One question about Postgres-XC, can it distribute one single query in
> all nodes ?
>
> Example,
> Nodes: Node1,Node2,Node3
> Query:"SELECT sum(foo) FROM bar group by f
On Sun, Mar 3, 2013 at 9:14 PM, Tom Lane wrote:
> The real difficulty is that there may be more than one storable value
> that corresponds to "1.23456" to six decimal digits. To be certain that
> we can reproduce the stored value uniquely, we have to err in the other
> direction, and print *more*
On Mon, Mar 4, 2013 at 1:01 PM, Daniel de Oliveira Mantovani <
daniel.oliveira.mantov...@gmail.com> wrote:
> just fixing:
>
> like Netezza which has full implementation to do it.*
>
> On 4 March 2013 14:59, Daniel de Oliveira Mantovani
> wrote:
> > One question about Postgres-XC, can it distribut
On Mon, Mar 4, 2013 at 2:27 PM, Maciek Sakrejda wrote:
> On Sun, Mar 3, 2013 at 9:14 PM, Tom Lane wrote:
>> The real difficulty is that there may be more than one storable value
>> that corresponds to "1.23456" to six decimal digits. To be certain that
>> we can reproduce the stored value unique
I don't understand the error resulting from the following progression on
9.2 (specifically "EnterpriseDB 9.2.1.3 on x86_64-unknown-linux-gnu,
compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit"):
select sysdate => timestamp without time zone
select timestamptz(sysdate) => timestam
Hi
Oracle defines database (schema) objects and "non-schema" objects (see [1]).
Is there also such a thing in Postgres?
Yours, Stefan
[1] http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements007.htm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
On 3/5/2013 2:03 AM, Stefan Keller wrote:
Hi
Oracle defines database (schema) objects and "non-schema" objects (see [1]).
Is there also such a thing in Postgres?
Yes. See, for example, CREATE USER, CREATE TABLESPACE and CREATE SCHEMA.
--
Guy Rouillier
--
Sent via pgsql-general mailing lis
13 matches
Mail list logo
