Re: [GENERAL] rotate records

2006-02-27 Thread Natasha Galkina
| val +- 1 | 16 2 | 17 As you can see the record with value '14' is gone without explicit delete, which is not what I expected. Do you have any ideas on how to avoid this? Natasha Galkina. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

[GENERAL] rotate records

2006-02-25 Thread Natasha Galkina
Hello. Im using Postgresql 7.3 on Linux. I created sequence CREATE SEQUENCE event_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 5 START 1 CACHE 1 CYCLE; And I created table which uses this sequence as primary key. CREATE TABLE hw_messages ( event_id INT PRIMARY KEY