Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group