permission errors for set authority and schema public
Started by CSNover 22 years ago2 messagesgeneral
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.
Are these errors due to new features in 7.4? Do I need
to add more permissions for users?
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
Re: permission errors for set authority and schema public
CSN writes:
I upgraded to 7.4 a few days ago and am getting these
errors when importing dumps: "permission denied to set
session authority" and "permission denied for schema
public". Not all of the dump is imported successfully.
Looks like you need to restore as superuser.
--
Peter Eisentraut peter_e@gmx.net