Port Bug Report: unable to delete table due to "heap_delete" error

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: unable to delete table due to "heap_delete" error
Date: 1999-05-06 14:45:31
Message-ID: 199905061445.KAA37571@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Diab Jerius
Your email address : djerius(at)cfa(dot)harvard(dot)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:
---------

--------------------------------------------------------------------------

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-05-06 15:27:07 Port Bug Report: Query processing seems broken
Previous Message Bruce Momjian 1999-05-05 21:46:28 Re: [PORTS] Port Bug Report: yacc bombs table size