'DROP VIEW' crashes - Mailing list pgsql-bugs

From Piotr Kucharski
Subject 'DROP VIEW' crashes
Date
Msg-id 19990424194514.P10163@sgh.waw.pl
Whole thread Raw
List pgsql-bugs
Name               : Piotr Kucharski
  Email address      : chopin@sgh.waw.pl
  Architecture (example: Intel Pentium)         : Ultra Sparc
  Operating System (example: Linux 2.0.26 ELF)  : Solaris 2.6
  PostgreSQL version (example: PostgreSQL-6.4.2)  : PostgreSQL-6.4.2
  Compiler used (example:  gcc 2.8.0)           : gcc 2.8.1


$ ./postgres informator

POSTGRES backend interactive interface
$Revision: 1.94 $ $Date: 1998/10/16 06:05:13 $

> CREATE VIEW vname AS SELECT * FROM prof
blank
         1: rulename    (typeid = 19, len = 32, typmod = -1, byval = f)
         2: ev_type     (typeid = 18, len = 1, typmod = -1, byval = t)
         3: ev_class    (typeid = 26, len = 4, typmod = -1, byval = t)
         4: ev_attr     (typeid = 21, len = 2, typmod = -1, byval = t)
         5: is_instead  (typeid = 16, len = 1, typmod = -1, byval = t)
         6: ev_qual     (typeid = 25, len = -1, typmod = -1, byval = f)
         7: ev_action   (typeid = 25, len = -1, typmod = -1, byval = f)
        ----
> DROP VIEW vname
Bus Error (core dumped)

$ gdb ./postgres core
Core was generated by `./postgres informator'.
Program terminated with signal 10, Bus error.
"/usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1": not in executable format: File format not recognized.
#0  0x47a7c in heapgettup (relation=0x309ea8, tid=0x0, dir=1, buf=0x35780c, snapshot=0x0,
    nkeys=1, key=0x346588) at heapam.c:409
409                             HeapTupleSatisfies(lpp, relation, *buf, (PageHeader) dp,
(gdb) bt
#0  0x47a7c in heapgettup (relation=0x309ea8, tid=0x0, dir=1, buf=0x35780c, snapshot=0x0,
    nkeys=1, key=0x346588) at heapam.c:409
#1  0x4a1b0 in heap_getnext (scandesc=0x3577f8, backw=0) at heapam.c:926
#2  0x6fe20 in DeletePgTypeTuple (rel=0x34cb08) at heap.c:1163
#3  0x7002c in heap_destroy_with_catalog (relname=0x21a200 "vname") at heap.c:1259
#4  0x8b724 in RemoveView (viewName=0x21a200 "vname") at view.c:320
#5  0x141724 in ProcessUtility (parsetree=0x2ecd50, dest=Debug) at utility.c:503
#6  0x13da3c in pg_exec_query_dest (query_string=0xefffd8e8 "DROP VIEW vname\n", dest=Debug,
    aclOverride=0 '\000') at postgres.c:758
#7  0x13d898 in pg_exec_query (query_string=0xefffd8e8 "DROP VIEW vname\n") at postgres.c:699
#8  0x13f684 in PostgresMain (argc=2, argv=0xeffff9ec, real_argc=2, real_argv=0xeffff9ec)
    at postgres.c:1645
#9  0xbb114 in main (argc=2, argv=0xeffff9ec) at main.c:107

pgsql-bugs by date:

Previous
From: "Vladimir N.Silyaev"
Date:
Subject: nested queries with IN statement
Next
From: Unprivileged user
Date:
Subject: General Bug Report: Case statements in selects with table joins causes psql to abort