sequence last_value

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Cc: "Hamish Whittal (DNS)" <hamishw(at)iafrica(dot)com>
Subject: sequence last_value
Date: 2001-10-08 10:03:54
Message-ID: C54EF5B83335D311BCB50000C11042B102C8C659@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Herb Blacker 2001-10-08 15:34:06 Loading current_user and current_timestamp using COPY
Previous Message Roth, Michael J. 2001-10-08 08:43:56 Why the table allocates so much Space ?