| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | "Josh Harrison" <joshques(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgres catalog files problem |
| Date: | 2007-09-17 17:35:52 |
| Message-ID: | C36939E7-C7BD-481A-B4E7-2457E5D83A8F@myemma.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sep 17, 2007, at 12:31 PM, Josh Harrison wrote:
> Thanks.
> Actually Im currently testing "oracle to postgres migration" with a
> small dataset. I haven't started working with the real dataset. I
> wanted to check with a small dataset before I start with the big one.
> I know the records that I deleted from the pg_class file. so what
> do i do next? Will it help if I drop the problematic tables and
> recreate them? (like i said im currently testing with a small
> datset only and my real data are in oracle and they are not messed
> in nay way). What will happen to my catalog files if i do that?
> Josh
If you can successfully drop those tables, then yes. Given that this
is just a test database, if you have any issues doing that, I'd scrap
the whole database.
Erik Jones
Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-09-17 17:44:30 | PostgreSQL Conference Fall 07, all speaker slots filled! |
| Previous Message | Josh Harrison | 2007-09-17 17:31:29 | Re: postgres catalog files problem |