Re: [BUGS] BUG #6093: timeout

2011-07-06 Thread Jaime Casanova
Craig Ringer writes: > -ENOCOFFEE > LOL. this one is the best i have heard this year -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL Soporte 24x7, desarrollo, capacitación y servicios -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to yo

Re: [BUGS] BUG #6093: timeout

2011-07-06 Thread Craig Ringer
On 07/07/11 12:49, Craig Ringer wrote: >> pgcluster-1.9.0rc7.tar.gz;postgresql-8.3.6.tar.bz2,pgreplication.conf >> default longest timeout is one hours,how do ignore this? > > [snip] A google search suggests you might be talking about > PgCluster. Sorry. I'm totally blind; you mention pgcluster

Re: [BUGS] BUG #6093: timeout

2011-07-06 Thread Craig Ringer
On 07/07/11 10:36, wbc wrote: > Operating system: linux5.5 There is no such thing as Linux 5.5 . Do you mean "Red Hat Enterprise Linux 5.5" or "SuSE" or "CentOS" or ? > pgcluster-1.9.0rc7.tar.gz;postgresql-8.3.6.tar.bz2,pgreplication.conf > default longest timeout is one hours,how do igno

Re: [BUGS] BUG #6093: timeout

2011-07-06 Thread Devrim GÜNDÜZ
On Thu, 2011-07-07 at 02:36 +, wbc wrote: > > pgcluster-1.9.0rc7.tar.gz;postgresql-8.3.6.tar.bz2, > pgreplication.conf default longest timeout is one hours,how do ignore > this? pgcluster is an abandoned project. I suggest you to use another replication/clustering software. -- Devrim GÜNDÜ

[BUGS] BUG #6093: timeout

2011-07-06 Thread wbc
The following bug has been logged online: Bug reference: 6093 Logged by: wbc Email address: wbc_...@163.com PostgreSQL version: 8.3.6 Operating system: linux5.5 Description:timeout Details: pgcluster-1.9.0rc7.tar.gz;postgresql-8.3.6.tar.bz2,pgreplication.conf defaul

Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-06 Thread Tom Lane
Jeff Frost writes: > On 07/05/11 17:06, Tom Lane wrote: >> "Jeff Frost" writes: >>> Ran into a situation with a customer who is using the btree_gist contrib >>> module to allow combined index of some tsearch data and two other columns. >>> One of these other columns is a bigint field. I noticed

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Tom Lane
Jeff Davis writes: > On Wed, 2011-07-06 at 13:25 -0400, Tom Lane wrote: >> Actually, I'd just been working on this myself. I think the cleanest >> solution will be to get rid of the duplicative logic by making >> predtest.c use get_op_btree_interpretation(). That will require >> changing get_op_

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Jeff Davis
On Wed, 2011-07-06 at 13:25 -0400, Tom Lane wrote: > Actually, I'd just been working on this myself. I think the cleanest > solution will be to get rid of the duplicative logic by making > predtest.c use get_op_btree_interpretation(). That will require > changing get_op_btree_interpretation() so

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Tom Lane
Jeff Davis writes: > On Tue, 2011-07-05 at 13:56 -0400, Tom Lane wrote: >> Yeah, I had been thinking along the same lines. It will require >> duplicating the search loop, which is a bit annoying, but perhaps that >> could be factored out as a subroutine. > Patch attached. The logic in predtest.c

Re: [BUGS] BUG #6092: specific casting required for gist indexing of bigint

2011-07-06 Thread Jeff Frost
On 07/05/11 17:06, Tom Lane wrote: > "Jeff Frost" writes: >> Ran into a situation with a customer who is using the btree_gist contrib >> module to allow combined index of some tsearch data and two other columns. >> One of these other columns is a bigint field. I noticed that the combined >> index

Re: [BUGS] Re: PG regression with row comparison when btree_gist is enabled (BUG)

2011-07-06 Thread Jeff Davis
On Tue, 2011-07-05 at 13:56 -0400, Tom Lane wrote: > Yeah, I had been thinking along the same lines. It will require > duplicating the search loop, which is a bit annoying, but perhaps that > could be factored out as a subroutine. Patch attached. The logic in predtest.c was a little more complex,

Re: R: Re: [BUGS] BUG #6091: Information

2011-07-06 Thread Craig Ringer
[top-posting because the OP didn't seem to see my first reply below theirs] I repeat: this is not a bug report. SQL dumps from one database are not expected to work in a different database system from a different vendor. There are various migration and conversion tools that make it easier. It

Re: [BUGS] BUG #6091: Information

2011-07-06 Thread Craig Ringer
On 6/07/2011 5:24 AM, giuseppe petazzoni wrote: I pg_dump .sql data and schema but is no compatible db2 or mysql or informix or oracle No, it won't be. Few if any SQL databases are fully compatible with each other. In particular, the schema definitions (DDL) and type names tend to vary wildl

[BUGS] BUG #6091: Information

2011-07-06 Thread giuseppe petazzoni
The following bug has been logged online: Bug reference: 6091 Logged by: giuseppe petazzoni Email address: giuseppe.petazz...@libero.it PostgreSQL version: 8.4.7 Operating system: linux debian 6.0.1 Description:Information Details: Dear Ser I pg_dump .sql data and