Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> My instinct would be to follow your first strategy, i.e. detect which 
> path is needed rather than try one and then if it fails do the other.

The very first thing you need to think about is how to solve the race
condition problem, ie, two backends concurrently trying to insert
identical data.  Until you have a plausible mechanism for that, the
whole thing is pie-in-the-sky.

			regards, tom lane

In response to

• Re: UPSERT at 2007-03-02 14:35:20 from Andrew Dunstan

Responses

• Re: UPSERT at 2007-03-02 15:41:56 from Heikki Linnakangas
• Re: UPSERT at 2007-03-04 12:55:47 from Hannu Krosing

pgsql-hackers by date

Next:	From: Pavan Deolasee	Date: 2007-03-02 15:32:02
	Subject: Re: HOT - whats next ?
Previous:	From: Tom Lane	Date: 2007-03-02 15:08:19
	Subject: Re: HOT - whats next ?