> -----Original Message----- > From: Keehan Mallon [mailto:[EMAIL PROTECTED]] > Sent: 30 April 2002 22:40 > To: Dave Page; [EMAIL PROTECTED] > Subject: Database Migration Plugin and OIDs > > > Dave, > > I am now successfully using the Database Migration plugin to > PgAdmin II, but I still have a couple of questions: > > 1) Is it possible to do a migration without OIDs???? If not, > how do I go about dealing with the tables to get rid of the oids? No, you can't yet migrate without OIDs. You could possible remove them with some SQL like: CREATE TABLE xxx WITHOUT OIDS; INSERT INTO xxx (SELECT * FROM yyy); DROP TABLE yyy; ALTER TABLE xxx RENAME TO yyy; > 2) I am still having trouble with the Import plugin. If I > use the database migration utility to create the tables, then > create csv files from the Access DB, then import them using > the plugin I get a failure from the first row. > > Another thing that is annoying is that the transaction > continues until the last row is tried to import and then it > fails due to the error in the first record. Argh! Yes, it is a touch finicky. Can you supply the first few lines of the file and your target table definition? Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
