Re: [SQL] failed to build any 5-way joins

"Alessandro Depase" <[EMAIL PROTECTED]> writes: > select * > from info where parent_infoid is null=20 > and fieldtypeid in (select fieldtypeid from users_auth_groups uag1, field_a= > uth fa where userid =3D 8 and fa.groupid =3D uag1.groupid)=20 > and main_infoid in (select ic.infoid from info_cate

Re: [SQL] failed to build any 5-way joins

Thanks Tom, but I think I can wait, being possible to use the exists clause and not having, at the moment a big database. When there will be the less-drastic fix you refer to, I will use it and change my query. Thanks again. Bye Alessandro Depase - Original Message - From: "Tom Lane"

[SQL] migration between databases and versions

I have been Red Hat linux 7.3 on my prod server. I have been running postgres 7.2 on it. I would like to upgrade it to the newest version of postgres. 1) Is there a version for redhat 7.3. 2) How stable is postgres 7.4 ? I have another critical isssue. My database has now changed.In our new release

Re: [SQL] migration between databases and versions

Hi Mohan, I'm running 7.4 on a reasonably old version of turbo linux, on and even older creakier machine and it seems fine so far. I suspect I may be having some problems due to the fact that the development environment is 3 linux servers running under virtual pc on one windows 2000 box. :) I'm f