sequence last_value
От | Duncan Adams (DNS) |
---|---|
Тема | sequence last_value |
Дата | |
Msg-id | C54EF5B83335D311BCB50000C11042B102C8C659@vodabemail1.vodacom.co.za обсуждение исходный текст |
Список | pgsql-novice |
i have found that the value of last_value increases by one every time i do a single entry in to the table. if the table has an index of the value of Last_value them the insert fails, if the index is not in the table column 'key_location' then the insert is executed ether way the value of last_value increases. but if I try to insert multiple entry's, with a for next loop then all entry's fail and the value of last_value does not increase. I've tried vacuumdb, if anyone can tell me what it all means that would be great. ........................................ NOTICE: --Relation loc_old-- NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 30: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 2, MinLen 48, MaxLen 48; Re-using: Free/Avail. Space 6616/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. NOTICE: Index location_pkey: Pages 2; Tuples 30: Deleted 0. CPU 0.00s/0.00u sec. NOTICE: --Relation pg_rules-- NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. NOTICE: --Relation pg_views-- NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. NOTICE: --Relation loc-- NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 32: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 108, MinLen 48, MaxLen 56; Re-using: Free/Avail. Space 6072/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. NOTICE: Index loc_pkey: Pages 2; Tuples 32: Deleted 0. CPU 0.01s/0.00u sec. ........................................ what else should i be looking at? thanx from at a loss. for more info check my two last posts
В списке pgsql-novice по дате отправления: