Re: Using a lock to avoid: could not open relation with OID

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Using a lock to avoid: could not open relation with OID
Дата
Msg-id cone.1263271247.78794.2771.1000@shelca
обсуждение исходный текст
Ответ на Using a lock to avoid: could not open relation with OID  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-general
Craig Ringer writes:

> Possible workaround: Instead of your table creation, renaming and
> dropping, use TRUNCATE.

Have to support both 8.1 and 8.4.
If I recall correctly 8.1 did not support truncate inside of a transaction.

We are in the process of upgrading everything to 8.4, but until then.. have
to deal with all the 8.1 and 8.2 machines.

В списке pgsql-general по дате отправления:

Предыдущее
От: AI Rumman
Дата:
Сообщение: Re: transaction logging in the form of SQL statements
Следующее
От: AI Rumman
Дата:
Сообщение: location for pg_default tablespace