"Brian Mueller" <brian@twotomatoes.com> writes:
> When doing a large query from either an OpenACS 3.2.2 web page (/intranet/e=
> mployees/admin/index.tcl) or from psql, I get the following error:=20
> NOTICE: PortalHeapMemoryFree: 0x0x41a37610 not in alloc set!
> NOTICE: PortalHeapMemoryFree: 0x0x41a37cc8 not in alloc set!
> NOTICE: PortalHeapMemoryFree: 0x0x41a37ca0 not in alloc set!
> ERROR: btree scan list trashed; can't find 0x0x41a37bf0
Interesting. However, I can't get excited about having to
reverse-engineer your database before I can try to duplicate the
problem. How about a schema dump (pg_dump -s)? Also, what query
plan is shown by EXPLAIN for the problem query?
regards, tom lane