From: | Ben Marklein <the_pharcyde(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump/pg_restore problems with 7.4.1 |
Date: | 2004-01-14 23:27:43 |
Message-ID: | 20040114232743.4037.qmail@web11509.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to migrate from 7.2 to 7.4.1 via
pg_dump/pg_restore and have encountered a couple of
problems:
1) Index creation on a table fails:
db=# CREATE UNIQUE INDEX person_info_username_ix ON
person_info USING btree (username);
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
Of course, this index existed in the 7.2 DB, so it
seems odd that it should not be possible to recreate.
Furthermore, a search for duplicate values fails:
db=# select username, count(*) from person_info group
by username having count(*) > 1;
username | count
----------+-------
(0 rows)
Is this a known issue or possibly a bug?
2) While importing I get: "ERROR: invalid memory
alloc request size 1073741824". I tracked this down
to a line with some non-ASCII characters. The type of
the new database is LATIN1, and these are valid LATIN1
characters. I googled for the error message and found
a bug report that sounds like the same problem:
http://www.mail-archive.com/pgsql-bugs(at)postgresql(dot)org/msg07363.html
Anyone know if this was confirmed as a bug, and
whether it's being looked into? Thanks.
Ben
Ben
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2004-01-14 23:28:58 | Re: Documentation search (Was: Postgress and MYSQL) |
Previous Message | Joshua D. Drake | 2004-01-14 23:12:59 | Re: Postgress and MYSQL |