"Romina N. Tulisi" <romina(at)spcom(dot)com(dot)ar> writes:
> I've been trying to do a natural inner join with postgresql. However,
> when I try to do that I loose my connection to the database.
The "inner join" syntax support in 7.0 is really just beta-quality
code; it's got a few bugs. I'd suggest writing the query without
using inner join syntax, ie plain old
SELECT ... FROM a,b WHERE a.x = b.x;
JOIN syntax will work a lot better in 7.1.
regards, tom lane