A trigger did work, thank you for that suggestion.
In a race situation, there really is no manual solution either
I sent in a bug report for the rule problem that I experienced.
Sim
Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> I don't think rules can do what you want.
>
> A trigger might work, ignoring the problem of race conditions between
> two inserts happening concurrently (which a rule can't handle either).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>