I just saw this in my logs:

2002-09-18 12:13:10 ERROR:  cannot open segment 1 of relation users_sessions
(target block 1342198864): No such file or directory

This query caused it:

DELETE FROM users_sessions WHERE changed < ('now'::timestamp - '1440
minutes'::interval)  AND name = 'fhnid';

However, I cannot repeat the error now.  Is this a bug in postgres

Also, what should I do to fix the table properly.  I haven't vacuumed it or
anything yet in case someone wants to analyze it.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to