PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15572
PG Version10.5
OSRDS (on Amazon)
Opened2019-01-03 20:27:33+00
Reported byAsh Marath
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15572
Logged by:          Ash Marath
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-01-03 20:27:33+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-04 04:45:16+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-04 06:10:05+00"David G(dot) Johnston"BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-04 23:01:51+00a MarathRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-04 23:04:48+00a MarathRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-07 14:18:49+00a MarathRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-07 14:54:03+00Alvaro HerreraRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-07 23:55:54+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-09 00:36:06+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-01-15 23:38:55+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-04 23:14:09+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-06 12:17:23+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-10 22:05:54+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-10 22:39:19+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-11 02:36:17+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-12 03:09:27+00Michael PaquierRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-14 13:42:35+00Arthur ZakirovRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-17 22:15:19+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-17 22:17:52+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-17 22:31:43+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-17 23:38:20+00Michael PaquierRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 16:00:26+00Julien RouhaudRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 16:45:59+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 17:48:04+00Julien RouhaudRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 20:01:45+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 20:03:50+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 20:21:42+00Julien RouhaudRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-19 20:57:19+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-20 05:56:27+00Michael PaquierRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-20 08:34:15+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-20 20:36:39+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-02-21 01:29:33+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-03-03 20:14:13+00Tom LaneRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name
2019-03-10 15:18:37+00David RowleyRe: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name