From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <keehan_mallon(at)yahoo(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Database Migration Plugin and OIDs |
Date: | 2002-05-01 07:24:43 |
Message-ID: | 214E9C0A75426D47A876A2FD8A07426E6661@salem.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-05-01 07:27:04 | Re: pgMigration installation error |
Previous Message | Brent Lassi | 2002-05-01 01:52:54 |