Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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:
---------


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


pgsql-ports by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group