Re: [GENERAL] ERROR: JoinClauseSelectivity

VACUUM ANALYZE the table.

> Hi everyone,
>
> I'm trying to do a simple join query and I get an error message.
> My tables are :
> agency(agencyid serial, agency_name text, address text, ...)
> groupleader(leaderid serial, agency_name text, phonenum text , ...)
>
> The query :
> SELECT agencyid FROM agency, groupleader WHERE
> agency.agency_name=groupleader.agency_name;
>
> The error message :
> ERROR: JoinClauseSelectivity: bad value 2.450299
>
> I tried the query in other forms such as:
> SELECT * FROM agency, groupleader WHERE
> agency.agency_name=groupleader.agency_name;
> and
> SELECT * FROM agency WHERE
> agency_name=groupleader.agency_name;
>
> I get the same error message. What am I doing wrong here ?
>
> Thanks for your help,
> -Sheila
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026