occasional core dump problem

Hey, I've got a problem where my backend occasionally dumps core, and
closes connections to all my clients. This is for my photo album project (
http://bleu.west.spy.net/~dustin/photo/ if anyone's interested). What I'm
doing is MIME encoding all of my images and storing them in normal text fields.
I do this for various reasons, it works fine except for the core dumps. My
query looks something like this:

select * from image_store where id=
(select id from image_map where name='89452648824743.jpg')
order by line

And the stack trace looks like this (OBTW, it's a seg fault):

> 0 nocachegetattr(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["heaptuple.c":0,
0x422268]
1 ExecEvalVar(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execQual.c":0, 0x4899b8]
2 ExecEvalExpr(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execQual.c":0, 0x48b48c]
3 ExecTargetList(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execQual.c":0,
0x48ba70]
4 ExecProject(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execQual.c":0, 0x48bdf0]
5 ExecScan(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execScan.c":0, 0x48c004]
6 ExecIndexScan(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["nodeIndexscan.c":0,
0x495594]
7 ExecProcNode(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execProcnode.c":0,
0x488988]
8 createfirstrun(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["psort.c":0, 0x58c23c]
9 initialrun(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["psort.c":0, 0x58bdf8]
10 psort_begin(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["psort.c":0, 0x58bb60]
11 ExecSort(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["nodeSort.c":0, 0x499280]
12 ExecProcNode(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execProcnode.c":0,
0x4889fc]
13 ExecutePlan(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execMain.c":0, 0x487758]
14 ExecutorRun(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["execMain.c":0, 0x486cc4]
15 ProcessQueryDesc(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["pquery.c":0,
0x535504]
16 ProcessQuery(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["pquery.c":0, 0x535600]
More (n if no)?
17 pg_exec_query_dest(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["postgres.c":0,
0x533490]
18 pg_exec_query(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["postgres.c":0,
0x533260]
19 PostgresMain(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["postgres.c":0, 0x5348f0]
20 main(0x4, 0x3, 0x100bb690, 0x7fff0a6c) ["main.c":0, 0x4ade98]
21 __istart() ["crt1tinit.s":13, 0x4203a0]

Anyone know what's going on? I can easily generate another core if
anyone wants any more info.

--
SA, software.net My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________