Re: [GENERAL] bug in 6.4.2?

On Mon, 31 May 1999, Bruce Momjian wrote:

> >
> > i was recently importing a fairly large amount of data from a mysql to
> > postgres ( 6.4.2 ).  to make a long story short, this involved some
> > renames ( alter table foo rename to bar ).  two psql clients were running,
> > accessing the same database and, in some cases, querying on the same
> > table.  when one tried to insert into one of the recently
> > dropped-and-renamed tables, it produced an error saying that an attribute
> > didnt exist for <old table's OID>.  a restart of that app fixed it.
> >
> > fyi, the error was "get_attisset: no attribute requests in relation
> > 902432" while doing an insert.  a select statement just returned 0 rows,
> > even though there were 1 or 2 matching the query ( verified in the psql
> > window i was working in, doing the renames ).
> >
> > is this a known problem ?  do the clients cache OIDs or some such ?  is
> > there anything i can do, apart from the obvious ( heh ), to make sure
> > this doesnt happen again ?
>
> In 6.4.*, table renaming was not properly flushing the cache, I think.
> Should work fine when 6.5 is released.

i had figured the client was caching OIDs.  _really_ looking forward to
6.5, keep up the great work!

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"Do a little dance, make a little code, compile tonight... compile tonight."