"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> PostgreSQL version: 7.4
> Description: "insert into" from "select" crashes backends
This is fixed in 7.4.2 --- or at least we fixed a couple of very similar
symptoms. Please update, and resubmit if you still see it.
regards, tom lane