>
> 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.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026