Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> Things are still not so good for me. The pg_dumpall > file, psql < file did
> work, but later:
> newnham=> select * from crsids,"tblPerson" where
newnham-> crsids.crsid != "tblPerson"."CRSID";
> Backend sent B message without prior T
> D21Enter data to be copied followed by a newline.
> End with a backslash and a period on a line by itself.
>>>
> which smells like a similar problem. (Note that this is a join. Straight
> selects didn't cause problems)
Bizarre. Obviously, the frontend and backend have gotten out of sync,
but it's not too clear who's to blame. Since you also mention
> (New also, though probably unrelated: the sanity check fails with number of
> index tuples exactly half number in heap - not equal)
I think that you may have some subtle platform-specific problems in the
backend.
What exactly is your platform/compiler/configuration, anyway?
regards, tom lane