错误：必须是角色“”PostgreSQL的成员

概述我需要更改表的所有者. 我创建了表格： CREATE TABLE example (some columns); 然后我试图改变主人： ALTER TABLE database.expample OWNER TO "secondary"; 他们我得到了这个错误： ERROR: must be member of role "secondary" 有谁能够帮我？ 提前致谢. 从Postgresql文 我需要更改表的所有者.
我创建了表格：

CREATE table example (some columns);

然后我试图改变主人：

ALTER table database.expample OWNER TO "secondary";

他们我得到了这个错误：

ERROR: must be member of role "secondary"

有谁能够帮我？
提前致谢.

从Postgresql文档中看到这个：

http://www.postgresql.org/docs/current/static/sql-altertable.html

You must own the table to use ALTER table. To change the schema of a table,you must also have CREATE privilege on the new schema. To alter the owner,you must also be a direct or indirect member of the new owning role,and that role must have CREATE privilege on the table’s schema. (These restrictions enforce that altering the owner doesn’t do anything you Couldn’t do by dropPing and recreating the table. However,a superuser can alter ownership of any table anyway.)

总结

以上是内存溢出为你收集整理的错误：必须是角色“”PostgreSQL的成员全部内容，希望文章能够帮你解决错误：必须是角色“”PostgreSQL的成员所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。