'DROP VIEW' crashes

From: Piotr Kucharski <chopin(at)sgh(dot)waw(dot)pl>
To: bugs(at)postgreSQL(dot)org
Subject: 'DROP VIEW' crashes
Date: 1999-04-24 17:45:14
Message-ID: 19990424194514.P10163@sgh.waw.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Name : Piotr Kucharski
Email address : chopin(at)sgh(dot)waw(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Unprivileged user 1999-04-26 00:02:42 General Bug Report: Case statements in selects with table joins causes psql to abort
Previous Message Vladimir N.Silyaev 1999-04-24 09:02:38 nested queries with IN statement