============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Diab Jerius
Your email address : djerius@cfa.harvard.edu
Category : runtime: back-end
Severity : serious
Summary: unable to delete table due to "heap_delete" error
System Configuration
--------------------
Operating System : Solaris 2.6
PostgreSQL version : 6.4.2
Compiler used : Sun cc 4.2
Hardware:
---------
SunOS fondue 5.6 Generic_105181-12 sun4m sparc SUNW,SPARCstation-20
Versions of other tools:
------------------------
flex version 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
I've created a table with the following properties:
CREATE TABLE "tst_runidstartstop" (
"runid" int4,
"irigstarttime" datetime,
"irigstoptime" datetime);
After some use, I attempted to drop it, and
received the following response:
spectral=> drop table tst_runidstartstop;
ERROR: heap_delete: (am)invalid tid
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
