Re: [HACKERS] suspected problem with cache updates - Mailing list pgsql-hackers

From darrenk@insightdist.com (Darren King)
Subject Re: [HACKERS] suspected problem with cache updates
Date
Msg-id 9803131739.AA65512@ceodev
Whole thread Raw
Responses Re: [HACKERS] suspected problem with cache updates  (jwieck@debis.com (Jan Wieck))
Re: [HACKERS] suspected problem with cache updates  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> >
> > I've noticed recently that after making certain changes to the
> > database (adding indices, attributes) they aren't immediately known
> > about.  for example, I add an attribute, then try to update that
> > attribute it tells me it doesn't exist.  if I exist psql and start a
> > new connection all is well.  but it doesn't happen consistently..
> >
> >
>
>     Looks like problems in the syscache/catcache invalidation
>     routines.
>

This existed in an older version, but I could almost swear that someone
fixed it.

Bruce, do you have old versions of the TODO lists around to check on
this one?  I specifically remember the part about adding an attribute
and it not being there until the next session.

darrenk

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: PL/PgSQL discussion
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] suspected problem with cache updates