BUG #15572: Misleading message reported by "Drop function operation"on DB with functions having same name
От | PG Bug reporting form |
---|---|
Тема | BUG #15572: Misleading message reported by "Drop function operation"on DB with functions having same name |
Дата | |
Msg-id | 15572-ed1b9ed09503de8a@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15572: Misleading message reported by "Drop functionoperation" on DB with functions having same name
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15572 Logged by: Ash Marath Email address: makmarath@hotmail.com PostgreSQL version: 10.5 Operating system: RDS (on Amazon) Description: Scenario: DB has 2 functions with same name. DB: testDB Schema: test Function 1: test.func1(param1 text, param2 text) Function 2: test.func1(param1 text) --------------------------------- Issue: Misleading message reported by "DROP FUNCTION" command with the above scenario Step 1: Run the command : DROP FUNCTION test.func1; NOTE: This operation failed to execute the drop and reported the following message Message reported by PgAdmin4 & OmniDB: ---- start of message ------ function name "test.func1" is not unique HINT: Specify the argument list to select the function unambiguously. ---- end of message ------ -------------------------------------------------------------------------------------------------------- Step 2: Run the command : DROP FUNCTION IF EXISTS test.func1; NOTE: This operation completed successfully without error and reported the following message Message reported by PgAdmin4 & OmniDB: ---- start of message ------ function admq.test1() does not exist, skipping ---- end of message ------ ----------------------------------------------------------------------------------------------------------- Proposed solution: The operation in Step 2 should have failed with the same error as reported in Step 1; Thanks Ash Marath makmarath@hotmail.com
В списке pgsql-bugs по дате отправления: