I have a problem with rule on a postgresql 7.0.3:

When I do
create rule truc as on insert to table do
insert into othertable (value) values (new.clef);

where clef is my primary key as serial, it jump one entry in the sequence table and my 
insert on the other table dosen't put the correct values.

But when I insert old.key, the value is the older, the not increment sequence.

Do you know if it is a bug, or what I'm doing wrong ? 

Olivier Thauvin-CNRS Service Aeronomie
01 64 47 43 60 à Verrières (lundi,mercredi et vendredi)
01 44 27 47 59 à Jussieu (Mardi et Jeudi)

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to