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