From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: makmarath@hotmail.com
Subject: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
Date: Thu, 03 Jan 2019 20:27:33 +0000
Message-ID: <15572-ed1b9ed09503de8a@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, makmarath@hotmail.com
Subject: Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
In-Reply-To: <15572-ed1b9ed09503de8a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox