Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA14670; Tue, 2 Jun 92 17:30:58 -0700 Date: Tue, 2 Jun 92 17:30:58 -0700 Message-Id: <9206030030.AA14670@postgres.Berkeley.EDU> From: David Feldcamp Subject: HELP: mystery error message To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu Cc: mer@postgres.berkeley.edu I am persistently getting the following message on a replace command (which immediately follows another on a different table, but otherwise identical which always works): WARN:Jun 2 17:28:53:heap_replace: (am)invalid otid What does this mean?? Does it have something to do with transaction ids? What can I do about it? Here is the monitor output from a monitor execution of the command (with the class states): Welcome to the C POSTGRES terminal monitor Go * retrieve (graph.all)\g Query sent to backend is "retrieve (graph.all)" --------------------------------------------------------- | mid | node | port | edge | --------------------------------------------------------- | 0 | Node 1 | (null) | Edge1 | --------------------------------------------------------- | 0 | Node 1 | (null) | Edge2 | --------------------------------------------------------- | 2 | Node 2 | (null) | Edge1 | --------------------------------------------------------- | 2 | Node 2 | (null) | Edge3 | --------------------------------------------------------- | 2 | Node 3 | (null) | Edge2 | --------------------------------------------------------- | 2 | Node 3 | (null) | Edge3 | --------------------------------------------------------- Go * retrieve (edge.all)\g Query sent to backend is "retrieve (edge.all)" ----------------------------------------------------------------------- | mid | name | weight | width | color | ----------------------------------------------------------------------- | 0 | Edge1 | 1 | 0 | 6 | ----------------------------------------------------------------------- | 0 | Edge2 | 1 | 0 | 6 | ----------------------------------------------------------------------- | 0 | Edge3 | 1 | 0 | 6 | ----------------------------------------------------------------------- Go * replace edge (mid = graph.mid) where (graph.mid = 2) and (graph.edge = edge.name) and (edge.mid = 0)\g Query sent to backend is "replace edge (mid = graph.mid) where (graph.mid = 2) and (graph.edge = edge.name) and (edge.mid = 0)" WARN:Jun 2 17:28:53:heap_replace: (am)invalid otid