Re: Database Migration Plugin and OIDs

> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon(at)yahoo(dot)com]
> Sent: 30 April 2002 22:40
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> 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.