Comment 1 for bug 897098

Revision history for this message
Nicola Riolini - Micronaet (nicolariolini) wrote : Re: problem after restore: there is no primary key for referenced table "res_users"

for workaroud I try via psql in restored DB:
ALTER TABLE res_user ADD PRIMARY KEY (id);
I see that the primary key is back but this procedure I'll need to do for all the tables that I find without.
what's going wrong in my backup procedure, is better use pg_dump / pg_restore?
Thanks