Please send a reproducable sample, with CREATE TABLE, INSERT, etc.
> Following up on the problem, here's a psql session that crashed:
>
> access=> begin;
> BEGIN
> access=> SELECT Seq, NAS, SessionID, COUNT(*), MIN(ID) AS ID
> access-> INTO TEMP T1
> access-> FROM Session
> access-> WHERE Account = '72638'
> access-> GROUP BY Seq, NAS, SessionID;
> SELECT
> access=> DELETE
> access-> FROM T1
> access-> WHERE Count = 1;
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally before or
> while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible. Terminating.
>
>
> If I don't put it in a transaction it doesn't crash. If I don't use TEMP
> it doesn't crash.
>
> This is the one I sent a backtrace of yesterday, the one crashing in
> nocachegetattr().
>
> Thanks,
> Anto.
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
