Re: [BUGS] Fall back to alternative tsearch dictionary directory

2009-01-24 Thread Martin Pitt
Hi Tom, Tom Lane [2009-01-14 20:56 -0500]: > Bruce Momjian writes: > > Uh, would someone eyeball and apply this? Thanks. > > I thought we had come to the conclusion that no patch was needed > because there's no convincing reason to look anyplace except > ${sharepath}/tsearch_data/. That's what

Re: [BUGS] Selecting from a Subquery Fails

2009-01-24 Thread Euler Taveira de Oliveira
Francesco Pari escreveu: > The query Hangs > > can this be a bug or a misconfiguration? > It isn't a bug unless you show us a backend's crash, memory leak, or another misbehavior. I suspect the second query is suffering from a bad plan. Try posting EXPLAIN ANALYZE of both queries to pgsql-pe

[BUGS] Selecting from a Subquery Fails

2009-01-24 Thread Francesco Pari
Hello, i have this big isuue: i have 2 table referenced by this columns codiceregistrazione=riferimentoesame; select tipoesame,count(*) from righeaccettazione,registrazione where codiceregistrazione=riferimentoesame and validita='VALIDO' and dataesame between timestamp '2008-01-01 00:00