Thread
-
'DROP VIEW' crashes
Piotr Kucharski <chopin@sgh.waw.pl> — 1999-04-24T17:45:14Z
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