[Karl der Heinz]

Hi,

I have a Firebird database and I want to delete old entries.
Before I start deleting old entries I check the oldest entry:

SELECT min(in_timestamp) FROM tsyslog;

Output was 2011-05-01 ...

So, I execute following command:

DELETE FROM tsyslog WHERE in_timestamp BETWEEN '2011-05-01' AND '2012-07-01';

After finishing I check the oldest entry:

SELECT min(in_timestamp) FROM tsyslog;

Output was 2012-07-01.

So, all fine. Then I did a Backup and Restore and check the oldest entry:

SELECT min(in_timestamp) FROM tsyslog;

Output was 2011-05-01....

Did I miss something? Why there are old entries?? There should be 2012-07-01.

Can you help me please? Thank you


greetings
Karl der Heinz!

[costin_mentor]

Try to do a commit command after your delete instruction:

DELETE FROM tsyslog WHERE in_timestamp BETWEEN '2011-05-01' AND '2012-07-01';

COMMIT;