"Dan Langille" <[EMAIL PROTECTED]> writes: > I am forwarding this on behalf of [EMAIL PROTECTED] who is at a client > site and cannot email.
> I did a search and found a mail stating that its possibly related to > a deleted user having ownership of the table. > "http://www.geocrawler.com/mail/msg.php3?msg_id=5653159&list=10"; I > checked and indeed the owner that created the table no longer exists. > Unfortunately I have no idea who that user was. You don't need to know. Get the old owner's sysid with SELECT relowner FROM pg_class WHERE relname = 'busted_table'; then create a user with the appropriate sysid: CREATE USER foo WITH SYSID nnn; Once you've done that, consider upgrading to a more recent Postgres. It's been a good long while since pg_dump would choke on this situation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
