Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] ERROR: JoinClauseSelectivity

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: sheila bel <sheilabel(at)hotmail(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] ERROR: JoinClauseSelectivity
Date: 2000-02-23 17:57:18
Message-ID: 200002231757.MAA04008@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
ALTER TABLE ADD COLUMN had a problem where selectivity was set to some
strange number.  This should be fixed in newer releases.


> Hi Bruce,
> 
> >
> >VACUUM ANALYZE the table.
> >
> 
> I did this and now my query is working. I don't understand
> what exactly VACUUM ANALYZE is doing and why I was getting
> the error message. Could you please explain.Thanks
> -Sheila
> 
> 
> > >
> > > 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
> 
> ______________________________________________________
> 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

In response to

pgsql-general by date

Next:From: davidbDate: 2000-02-23 18:40:45
Subject: Re: [GENERAL] scheduling table design
Previous:From: Ed LoehrDate: 2000-02-23 17:43:09
Subject: Re: [GENERAL] scheduling table design

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group