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 ?
thanks in advance.
---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"Do a little dance, make a little code, compile tonight... compile tonight."