[Babase] Dump problem?
Karl O. Pinc
kop at meme.com
Wed May 30 12:12:45 EDT 2007
Hi,
I've got the following errors in comparetables.out:
fpneighbors.TXT
--- /var/tmp/foxsource.31134 2007-05-30 07:12:06.000000000 -0400
+++ /var/tmp/postsource.31134 2007-05-30 07:12:08.000000000 -0400
@@ -259154,7 +259154,6 @@
206506 DAS 1
206507 DAS 1
206508 DAS 1
-206509 DAS 1
206510 DAS 1
206510 DAS A
206511 DAS 1
fpsamps.TXT
--- /var/tmp/foxsource.31134 2007-05-30 07:12:12.000000000 -0400
+++ /var/tmp/postsource.31134 2007-05-30 07:12:15.000000000 -0400
@@ -205694,7 +205694,6 @@
206506 37058 R 2 O S 15:34
206507 37058 R 2 O S 15:36
206508 37058 R 2 O S 15:37
-* 206509 37058 R S O S 15:37
206510 37058 R 2 O S 15:38
206511 37058 R 2 O S 15:40
206512 37058 R 2 O S 15:41
This is telling me that FPSAMPS with fpid 206509 is
in foxpro but not postgresql. But when I look
at the fpsamps.dbf file I don't see a 206509.
I suspect that the * means that the row was deleted
but somebody didn't do a "PACK" or whatever it is that
foxpro requires to actually get rid of a deleted row.
Then there's the row in fpneighbors. When I look for
it in the fpneighbors.dbf file it's not there. This
leads me to believe that the dump output does not
exactly correspond to the dbf files.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list