Unable to Restor Table Named "User" - Mailing list pgadmin-support

From Soule, Cathi (HQP)
Subject Unable to Restor Table Named "User"
Date
Msg-id 6FE8E301C4B5FB469E9FDEDACEF27D94AF596C@N1-1EXC-MBX06N2.na.msds.rhi.com
Whole thread Raw
Responses Re: Unable to Restor Table Named "User"
Re: Unable to Restor Table Named "User"
List pgadmin-support
<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal">We are not able to
restorea table using pgAdmin from object browser.  We have been successful using backup / restore functions with 30
othertables.  However, we are not able to restore one table named ‘user’.  Here are details:  Thank you!<p
class="MsoNormal"> <pclass="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span
style="mso-list:Ignore">-<spanstyle="font:7.0pt "Times New Roman"">          </span></span>pgAdmin version 1.20.0<p
class="MsoListParagraph"style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span
style="font:7.0pt"Times New Roman"">          </span></span>Windows 7, 64-bit<p class="MsoNormal"> <p
class="MsoNormal">Messagesreturned is as follows.  Note that a successful restore had 2 additional msgs (pg_restore:
processingdata for table "skillc" pg_restore: setting owner and privileges for TABLE DATA skillc). Defaults were used
onbackup and restore.  Does anyone know how to resolve? Thank you for any help!   <p class="MsoPlainText"> <p
class="MsoPlainText"> <pclass="MsoPlainText">MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE--<p
class="MsoPlainText">C:/ProgramFiles/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port<p
class="MsoPlainText">5432--username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table \"user\"
--schemaxyz1 --verbose "E:\20150611 Mig32QA user4.backup"<p class="MsoPlainText">pg_restore: connecting to database for
restore Process returned exit code 0. <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"><spanstyle="font-family:"Lucida Calligraphy"">Cathi Soule</span><p class="MsoNormal"><a
href="mailto:Cathi.Soule@roberthalf.com"><spanstyle="color:blue">Cathi.Soule@roberthalf.com</span></a><p
class="MsoNormal"> </div>

pgadmin-support by date:

Previous
From: "Jan-Peter Seifert"
Date:
Subject: Naming of 'valid until' in role properties
Next
From: Melvin Davidson
Date:
Subject: Re: Unable to Restor Table Named "User"