Thread

1. Error in select

   Shiby Thomas <sthomas@cise.ufl.edu> — 1998-02-04T19:15:10Z

   Hi,
   
   I get the foll.  error in a select statement:
   
   assoc=> select * from f1_temp where cnt > 1000;
   ERROR:  fmgr_info: function 0: cache lookup failed
   
   Without the where clause its fine.
   
   This is with today's (Feb 4) snapshot.
   
   --shiby
   
   
   
   
   

2. Re: [HACKERS] Error in select

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-04T19:35:03Z

   > 
   > Hi,
   > 
   > I get the foll.  error in a select statement:
   > 
   > assoc=> select * from f1_temp where cnt > 1000;
   > ERROR:  fmgr_info: function 0: cache lookup failed
   > 
   > Without the where clause its fine.
   > 
   > This is with today's (Feb 4) snapshot.
   > 
   
   Yep, we know the cause, and will fix it soon.  Sorry.
   -- 
   Bruce Momjian
   maillist@candle.pha.pa.us
   
   

3. Re: [HACKERS] Error in select

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-02-05T02:25:02Z

   > > I get the foll.  error in a select statement:
   > >
   > > assoc=> select * from f1_temp where cnt > 1000;
   > > ERROR:  fmgr_info: function 0: cache lookup failed
   > >
   > > Without the where clause its fine.
   > >
   > > This is with today's (Feb 4) snapshot.
   > >
   >
   > Yep, we know the cause, and will fix it soon.  Sorry.
   
   Try doing a "make clean; make install" since possibly the problem is due
   to my changing a few keywords (got rid of two!) in the parser. It seems
   this quite often requires a clean install since I don't know which
   places are affected and it affects more than just the parser directory.
   
   Don't need to reload the database though.
   
                                             - Tom