| From: | lucas(at)presserv(dot)org |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | New record position |
| Date: | 2005-03-30 13:50:17 |
| Message-ID: | 20050330105017.miuieky7u64gscgc@www.presserv.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello,
I am using Slackware Linux 10, Postgresql 8.0.1.
My computer had a incorrectly power down (last week) and I have executed the
vacuum command:
VACCUM FULL ANALYZE VERBOSE;
to recicle and verify my database.
Before the power-down, all records had inserted into a table have displayed at
LAST record. Like:
SELECT * from tb1;
f1 | f2
------|--------
rec1 | vl1
INSERT into tb1 values ('rec2','vl2');
SELECT * from tb1;
f1 | f2
------|--------
rec1 | vl1
rec2 | vl2
But After the power-down and vacuum, the new records inserted have appeared in
random location (FIRST, between other records, etc...). Ie:
INSERT into tb1 values ('rec3','vl3');
SELECT * from tb1;
f1 | f2
------|--------
rec1 | vl1
rec3 | vl3 <<=====
rec2 | vl2
Why it? I can't undestand why the new record location was change. Shouldn't it
apper at the LAST record???
What need I do??
Thank you.
--------
Lucas Vendramin
Brazil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-03-30 14:12:37 | Re: New record position |
| Previous Message | frank | 2005-03-30 10:33:11 | Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE |