Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On Thu, Jul 10, 2014 at 02:21:57PM +0300, Aryeh Leib Taurog wrote: > I'd like to do the following for large frequent updates on central > table with ~1m rows: > > 1. Create new table like original > 2. Populate new table > 3. DROP original table > 4. RENAME new table to original > > Some testing revealed that in pg 8.4 and 9.1, if another session > queries the table between 3 and 4, the query fails with error 'could > not open relation with OID nnn.' In pg 9.3 there's no error. > <https://gist.github.com/altaurog/ab0019837719d2a93e6b> > > This seems to be the topic of conversation here: > <http://www.postgresql.org/message-id/flat/12791.1310599941@sss.pgh.pa.us#12791.1310599941@sss.pgh.pa.us> > <http://www.postgresql.org/message-id/flat/20285.1340769074@sss.pgh.pa.us#20285.1340769074@sss.pgh.pa.us> > > Do I correctly infer that the change in behavior was an intentional > fix and that with pg >= 9.3 I can rely on the above method working > without any risk of this error in my queries? Yes, I think so. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
В списке pgsql-bugs по дате отправления: