Ok, that's what I figured. Thank you for writing back. Oh, and good to know about the not null constraint added

Hi!

Can I add a column to a primary key, or will I have to drop the current primary key and add a new one?

What is the retention period for the data in the user_sessions table? It doesn't seem very long, like 2 days maybe... :cry: vertica=> select sysdate, min(session_start_timestamp) from user_sessions; sysdate | min ----------------------------+------------------------------- 2014-04-16 09:09:45.784007...

Jim, I just saw your reply. That did work! But it seems weird to me. dbadmin=> update rand_test a set rn = (select randomint(10) from rand_test b where b.id = a.id); OUTPUT -------- 3 (1 row) dbadmin=> select * from rand_test; id | rn ----+---- 1 | 0 2 | 8 3 | 9 (3 rows) Hmm. Is there some sort of h...

sKwa, Here are the details: dbadmin=> select version(); version ------------------------------------ Vertica Analytic Database v6.1.2-0 (1 row) dbadmin=> \dt rand_test; List of tables Schema | Name | Kind | Owner | Comment --------+-----------+-------+---------+--------- public | rand_test | table |...

Thanks, sKwa! That's cool! I will use this solution

Thanks, Jim! That seemed to work... but not when it is part of an update statement. dbadmin=> select * from rand_test; id | rn ----+---- 1 | 2 | 3 | (3 rows) dbadmin=> update rand_test set rn = randomint(10); OUTPUT -------- 3 (1 row) dbadmin=> select * from rand_test; id | rn ----+---- 1 | 5 2 | 2 ...