Vikrant Rathore <vikrant@chemquick.com> writes:
> now i am firing a query like this:
> select r.uname from radius r, radiustemp rt where r.uname<>rt.uname and
> r.logdate<>rt.logdate and r.logtime<>rt.logtime;
> After some time i get response
> "Segmentation Error"
> core(sumped)
How big are your tables? That query will probably produce an output
row for almost every combination of a row from radius with a row from
radiustemp, which might overflow the allowed memory for your
application.
I suppose what you really want is to find the rows in radius that do
not have duplicates in radiustemp, but that query won't do it...
regards, tom lane