Thanks for the prompt reply Tom, What is wrong with random() ? The following snipped is working ... insert into part(id1, id2, filler) select 11 + round( (random()*9)::bigint,0) as id1, --- 11-20 range for id1 , as of definition round( (random()*20)::bigint,0) as id2, 'TTTTTTTTTTTESTTTTTZZZZZZZZZZZZZZZZZZZ' from generate_series(0,100000); Regards. Milen -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Tuesday, June 13, 2006 12:18 AM To: Milen Kulev Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Partitioning... "Milen Kulev" <makulev@xxxxxxx> writes: > But When I issue: > insert into part(id1, id2, filler) > select > round( (random()*20)::bigint,0) as id1, <---!!! Note that both partitions should be populated! > round( (random()*20)::bigint,0) as id2, > 'TTTTTTTTTTTESTTTTTZZZZZZZZZZZZZZZZZZZ' > from generate_series(0,100000); > ERROR: new row for relation "part_id1_0_10" violates check > constraint "part_id1_0_10_id1_check" Don't use random() in your test case. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
