bug in 6.4.2?
От | Howie |
---|---|
Тема | bug in 6.4.2? |
Дата | |
Msg-id | Pine.LNX.3.96.990531033022.19533J-100000@rabies.toodarkpark.org обсуждение исходный текст |
Ответы |
Re: [GENERAL] bug in 6.4.2?
|
Список | pgsql-general |
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."
В списке pgsql-general по дате отправления: