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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026