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