Re: [HACKERS] latest snapshot crashes backend - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] latest snapshot crashes backend
Date
Msg-id 364091A5.90855F0C@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] latest snapshot crashes backend  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] latest snapshot crashes backend
Re: [HACKERS] latest snapshot crashes backend
Re: [HACKERS] latest snapshot crashes backend
List pgsql-hackers
> Care to give us a table:
>  select * from pg_shadow where (usesysid is null and oid is null);

Sure, that's easy. Just negate your where clause:

tgl=> select * from pg_shadow
tgl-> where not (usesysid is null and oid is null);
pqReadData() -- backend closed the channel unexpectedly.

If you can reproduce this, will you have a chance to look at it? I don't
know where the problem is, but suspect that it is farther back than the
parser transformations. Rewrite system, optimizer, or executor??
                   - Tom


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Warning!!
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] latest snapshot crashes backend