Re: INSERT OU UPDATE WITHOUT SELECT?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Jonah H. Harris" <jonah.harris@xxxxxxxxx>, Waldomiro <waldomiro@xxxxxxxxxx>
Subject: Re: INSERT OU UPDATE WITHOUT SELECT?
From: PFC <lists@xxxxxxxxxx>
Date: Wed, 31 May 2006 00:35:15 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <36e682920605301405u4d665fcftbe0a97b5753f5209@xxxxxxxxxxxxxx>
References: <447C8F1D.8090404@xxxxxxxxxx> <36e682920605301405u4d665fcftbe0a97b5753f5209@xxxxxxxxxxxxxx>
User-agent: Opera M2/8.54 (Linux, build 1745)

PostgreSQL does not support MERGE at the moment, sorry.

Issue an UPDATE, and watch the rowcount ; if the rowcount is 0, issue anINSERT.Be prepared to retry if another transaction has inserted the rowmeanwhile, though.


	MERGE would be really useful.

Follow-Ups:
- Re: INSERT OU UPDATE WITHOUT SELECT?
  - From: Dave Dutcher
- Re: INSERT OU UPDATE WITHOUT SELECT?
  - From: Alvaro Herrera

References:
- INSERT OU UPDATE WITHOUT SELECT?
  - From: Waldomiro
- Re: INSERT OU UPDATE WITHOUT SELECT?
  - From: Jonah H. Harris

Prev by Date: Re: Getting even more insert performance (250m+rows/day)
Next by Date: Re: Optimizing a huge_table/tiny_table join
Previous by thread: Re: INSERT OU UPDATE WITHOUT SELECT?
Next by thread: Re: INSERT OU UPDATE WITHOUT SELECT?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux