Jean-Christophe Roux wrote:
Hi, Thanks four your answers. Let me give more details here. The table with the id not incrementing by 1 as I expected is named topics. I have three other tables that contain rules that on insert into those tables, some fields of the table Topic should be updated. Each of those three tables contain a column that refer to topics.id as a foreign key. Those three columns contain id automatically generated by sequences and I have not observed any problem
Start psql and on each of those tables run "\d <tablename>". Also run "select * from <sequencename>" for any sequences involved. Post results here - I suspect some clues will be contained therein.
Cheers, Steve
