Postgres Pro
Downloads
Home   >   mailing lists

Thread: DROPPING INDEX error

DROPPING INDEX error

From
Atif Jung
Date:
I'm trying to drop an index from called t_sub_ind_1 from table t_submissions using the role update_all. The role has been granted full access privileges on the table from which the index is to be dropped. However when trying to drop the index, sqlca.sqlerrm.sqlerrmc is reporting the following error:
 
must be owner of relation t_sub_ind_1 on line 1188
 
I then dropped the index manually from the database, logged in as myself and I have full administrator priviliges. Ran the code again and this time it fell over when trying to create the index, saying:
 
must be owner of relation t_submissions on line 1214
 
does not having full access privileges as role update_all, also entitle me to drop and create indexes?
 
Also how can I find out the owners of a table/index?
 
Thanks

Atif


Re: DROPPING INDEX error

From
Jayadevan M
Date:
> Also how can I find out the owners of a table/index?

SELECT * FROM PG_TABLES

SELECT * FROM PG_INDEXES

Regards,
Jayadevan





DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

Re: DROPPING INDEX error

From
Tom Lane
Date:
Atif Jung <atifjung@gmail.com> writes:
> does not having full access privileges as role update_all, also entitle me
> to drop and create indexes?

No.  DDL changes to a table require being the table's owner, or at least
a member of the owning role.

            regards, tom lane