Problem with rule
| From: | Olivier Thauvin | Date: | Wed, 07 Mar 2001 18:21:32 +0000 |
| Subject: | Problem with rule | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7166@lists.php.net to get a copy of this message | ||
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
olivier.thauvin@aerov.jussieu.fr
Téléphone:
01 64 47 43 60 à Verrières (lundi,mercredi et vendredi)
01 44 27 47 59 à Jussieu (Mardi et Jeudi)