On Mon, 15 Apr 2002, Bruce Momjian wrote: > Can you check your load and see if there is a PRIMARY key on the table > at the time it is being loaded.
There is not. I create the table with a PRIMARY KEY declaration, but I drop that index before doing the import, and do an ALTER TABLE to re-add the primary key afterwards. At one point I tried doing a load with all indices enabled, but after about eight or nine hours I gave up. (Typically the load takes about 30 minutes. This is using about 2% of the sample data.) > In the old days, we created indexes > only after the data was loaded, but when we added PRIMARY key, pg_dump > was creating the table with PRIMARY key then loading it, meaning the > table was being loaded while it had an existing index. I know we fixed > this recently but I am not sure if it was in 7.2 or not. Ah, I saw that fix. But I'm doing the load by hand, not using pg_restore. cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org