Ops.. I've got it, disregard my email - random() generates duplicate values
on 10 long sequence
:-)
sorry.
--
Best Regards,
Vlad Marchenko
- Original Message -
From: "Vlad Marchenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 29
--+-+-+---
(0 rows)
test=# INSERT INTO subscribers(email) SELECT (random()||'@domain4.com') from
subscribers;
ERROR: Cannot insert a duplicate key into unique index
subscribers_email_key
test=#
I assume that this is because of pure transaction data isolation?
---
Be