Problem: Sequence X Rule Reference!
От | Junior - Cotrijui |
---|---|
Тема | Problem: Sequence X Rule Reference! |
Дата | |
Msg-id | 20040721123800.663861272DE@int.cotrijui.coop.br обсуждение исходный текст |
Список | pgsql-bugs |
/*************************************************************************** ******************************* Hello my friends, I have a problem, please, see the example above: **************************************************************************** *******************************/ create table test1(myfield numeric(10)); create sequence test1_seq; create table test2(myfield text); create or replace rule test1_insert as on insert to test1 do insert into test2 values(new.myfield::text || new.myfield::text || new.myfield::text || new.myfield::text); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); insert into test1 values (nextval('test1_seq')); select * from test2; /*************************************************************************** ******************************** problem description: for each reference of 'new.campo' on rule 'teste1_insert' the sequence is called! is this a bug? how can i do to solve my problem? obtained result on table2 expected result on table2 --- table test1 --- --- table test 2 --- --- table test1 --- --- table test 2 --- 1 2345 1 1111 6 78910 2 2222 11 12131415 3 3333 16 17181920 4 4444 21 22232425 5 5555 26 27282930 6 6666 31 32333435 7 7777 36 37383940 8 8888 41 42434445 9 9999 Thanks! Junior - COTRIJUI e-mail / msn: junior@cotrijui.coop.br icq: 58055700 - skype: selvinojunior **************************************************************************** *******************************/ --- Outgoing mail is certified Virus Free. ABC Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004
В списке pgsql-bugs по дате отправления: