Hi Doug,
thanks for your answers so far. I think I should try to discuss that
matter in [pgsql-sql] instead.
On 27.01.2006 21:21, Doug McNaught wrote:
> Oliver Fürst <ofuerst@tsak.net> writes:
>
>>Basically I'm worried that the whole "relying on the last value of a
>>sequence" isn't such a great idea.
>
> 'currval()' is specifically written to Do The Right Thing. See the
> docs.
My problem isn't answered in the manual, otherwise I wouldn't have
asked. I know that sequences are working correct for transactions
(either implicit or explicit).
But is nowhere stated if (multiple) commands inside a rule are treated
as an implicit transaction as a whole.
Regards,
Oliver