From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | hackers(at)postgreSQL(dot)org (PostgreSQL-development) |
Cc: | wieck(at)sapserv(dot)debis(dot)de |
Subject: | crash on new system views |
Date: | 1998-09-13 20:28:18 |
Message-ID: | 199809132028.QAA09560@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This query crashes the backend. pg_rules is a new system view:
BEGIN WORK;
DECLARE c_matches BINARY CURSOR FOR
SELECT count(*)
FROM pg_attrdef t1, pg_rules t2
WHERE t1.adrelid = t2.oid
END WORK;
Partial backtrace is below. It is crashing in the optimizer.
---------------------------------------------------------------------------
#0 0x80e8a5b in datumIsEqual (value1=0, value2=0, type=26, byVal=0, len=4)
at datum.c:216
#1 0x809d8fe in _equalConst (a=0x82daf10, b=0x82e2dd0) at equalfuncs.c:213
#2 0x809e7b7 in equal (a=0x82daf10, b=0x82e2dd0) at equalfuncs.c:668
#3 0x809e909 in equal (a=0x82e3490, b=0x82e3930) at equalfuncs.c:738
#4 0x809d634 in _equalExpr (a=0x82e2550, b=0x82e2d10) at equalfuncs.c:88
#5 0x809e737 in equal (a=0x82e2550, b=0x82e2d10) at equalfuncs.c:644
#6 0x809dab6 in _equalClauseInfo (a=0x82e2710, b=0x82e2cd0)
at equalfuncs.c:289
#7 0x809e7e7 in equal (a=0x82e2710, b=0x82e2cd0) at equalfuncs.c:677
#8 0x809b52a in member (l1=0x82e2cd0, l2=0x82e38f0) at list.c:371
#9 0x809b692 in set_difference (l1=0x82e3970, l2=0x82e38f0) at list.c:476
#10 0x80b0c23 in create_index_path (root=0x82e1290, rel=0x82e1490,
index=0x82e1a90, restriction_clauses=0x82e38f0, is_join_scan=0 '\000')
at pathnode.c:274
#11 0x80a7778 in create_index_paths (root=0x82e1290, rel=0x82e1490,
index=0x82e1a90, clausegroup_list=0x82e3910, join=0 '\000')
at indxpath.c:1381
#12 0x80a65b5 in find_index_paths (root=0x82e1290, rel=0x82e1490,
indices=0x82e38d0, clauseinfo_list=0x82e36f0, joininfo_list=0x0)
at indxpath.c:155
#13 0x80a55cb in find_rel_paths (root=0x82e1290, rels=0x82e3750)
at allpaths.c:124
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Buller | 1998-09-14 00:16:37 | Compiling 6.4 on NetBSD-current/pc532 |
Previous Message | Billy G. Allie | 1998-09-13 20:09:28 | Re: [HACKERS] libpq++ shared library missing? |