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
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 ? |