It seems that when doing a dump/restore on databases with FTS1 enabled, the INSERT commands in the dump need column names. That is, if the dump looks like this:
INSERT INTO "foo" VALUES (x,y,z) You get the error SQL error: table foo has 4 columns but 3 values were supplied Apparently if the dump looks like this, things work fine: INSERT INTO "foo" (a,b,c) VALUES (x,y,z) So, question: is there a way to get the .dump command to emit dumps in the latter form? Thanks, - a -- PGP/GPG: 5C9F F366 C9CF 2145 E770 B1B8 EFB1 462D A146 C380 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
