[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