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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
