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@spy.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. ____________