Home > mailing lists

incorrect error message, while dropping PROCEDURE - Mailing list pgsql-hackers

From	Rushabh Lathia
Subject	incorrect error message, while dropping PROCEDURE
Date	December 14, 2017 07:31:18
Msg-id	CAGPqQf0chhf9A7X2F2Eko-JzrVemOsgSM=C=6Pg0xtyHeJocPA@mail.gmail.com Whole thread Raw
Responses	Re: incorrect error message, while dropping PROCEDURE
List	pgsql-hackers

Hi,

Currently if some one try to drop the PROCEDURE and

it don't have privilege or it's not an owner, than error message

still indicate object as FUNCTION.

Example:

postgres@37737=#drop procedure pro;
ERROR: must be owner of function pro

This doesn't look correct specially that now we have separate

object type as OBJECT_PROCEDURE. It seems like we need

to introduce new AclObjectKind for PROCEDURE and do the

necessary changes to pass the correct AclObjectKind.

PFA patch, where introduced new AclObjectKind (ACL_KIND_PROCEDURE),
msg for the new AclObjectKind, and passed it through at

appropriate places.

Also update the necessary "make check" expected output changes.

Regards,

Thanks,

Rushabh Lathia

From: Kyotaro HORIGUCHI
Date: 14 December 2017, 07:20:07
Subject: Re: Protect syscache from bloating with negative cache entries

From: Amit Langote
Date: 14 December 2017, 08:23:59
Subject: pg_(total_)relation_size and partitioned tables