Postgres Pro
Downloads
Home   >   mailing lists

Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Date
Msg-id 22509.1149112219@sss.pgh.pa.us
Whole thread Raw
In response to DELETE ... USING ... - 8.0 and 8.1 compatibility problem  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Miroslav Šulc
Date:
Subject: DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Next
From: "David Clarke"
Date:
Subject: Table design question