Re: bug in join?

Laurette Cisneros <laurette@nextbus.com> writes:
> This join worked last week and today it gets and error:
> select * from b, d
>  where b.address = d.address;
> It now fails with the following error:
> ERROR:  join_selectivity: bad value -0.121693

Probably what has changed is the pg_statistic data (VACUUM ANALYZE
results).  Please send the results of

select * from pg_stats where tablename = 'b';
select * from pg_stats where tablename = 'd';
        regards, tom lane