Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread Ron
On 12/2/20 4:23 PM, raf wrote: On Wed, Dec 02, 2020 at 02:08:41PM -0800, Adrian Klaver wrote: On 12/2/20 2:02 PM, Thomas Kellerer wrote: guy...@icloud.com schrieb am 02.12.2020 um 21:27: The Halloween problem is that it is a challenge for the database if you’re updating a field that is also

Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread raf
On Wed, Dec 02, 2020 at 02:08:41PM -0800, Adrian Klaver wrote: > On 12/2/20 2:02 PM, Thomas Kellerer wrote: > > guy...@icloud.com schrieb am 02.12.2020 um 21:27: > > > The Halloween problem is that it is a challenge for the database if > > > you’re updating a field that is also in the WHERE clau

Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread raf
On Wed, Dec 02, 2020 at 11:02:07PM +0100, Thomas Kellerer wrote: > guy...@icloud.com schrieb am 02.12.2020 um 21:27: > > The Halloween problem is that it is a challenge for the database if > > you’re updating a field that is also in the WHERE clause of the same > > query. > > > > I just saw a p

Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread Adrian Klaver
On 12/2/20 2:02 PM, Thomas Kellerer wrote: guy...@icloud.com schrieb am 02.12.2020 um 21:27: The Halloween problem is that it is a challenge for the database if you’re updating a field that is also in the WHERE clause of the same query. I just saw a presentation from someone about how in SQL Se

Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread Thomas Kellerer
guy...@icloud.com schrieb am 02.12.2020 um 21:27: The Halloween problem is that it is a challenge for the database if you’re updating a field that is also in the WHERE clause of the same query. I just saw a presentation from someone about how in SQL Server he recommended writing changes to a tem

Re: Is the Halloween problem an issue in Postgres

2020-12-02 Thread Tom Lane
guy...@icloud.com writes: > The Halloween problem is that it is a challenge for the database if you’re > updating a field that is also in the WHERE clause of the same query. > I just saw a presentation from someone about how in SQL Server he recommended > writing changes to a temp table and then

Is the Halloween problem an issue in Postgres

2020-12-02 Thread guyren
The Halloween problem is that it is a challenge for the database if you’re updating a field that is also in the WHERE clause of the same query. I just saw a presentation from someone about how in SQL Server he recommended writing changes to a temp table and then writing them to the table as bein