Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Дата
Msg-id 22509.1149112219@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DELETE ... USING ... - 8.0 and 8.1 compatibility problem  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Список pgsql-sql
Miroslav Šulc <miroslav.sulc@startnet.cz> writes:
> The problem is that I have application deployed both on pg 8.0 and pg
> 8.1. This syntax (using USING) is only valid for 8.1+ and syntax without
> USING is only valid for 8.0 and not for 8.1. I could write it using IN
> operators which works in both versions but the slowdown is not acceptable.

Set add_missing_from TRUE ...
        regards, tom lane


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

Предыдущее
От: Miroslav Šulc
Дата:
Сообщение: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Следующее
От: "David Clarke"
Дата:
Сообщение: Table design question