#11056: Alter Procedure name is not working in PostgresSQL database

raghavsingh reported 2013-12-16T05:03:00Z · last modified 2017-07-31T15:53:41Z

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	19.0

Product: Aqua Data Studio

Version: 15.0.0-dev-47

Build #: 35085

Build Date: 2013-Dec-03 08:12:45 AM

Database: PostgresSQL 9.2

Operating Environment: Linux (2.6.32-358.23.2.el6.x86_64, amd64) / UTF-8 / en / US / Oracle Corporation 1.7.0_40-b43

Alter Procedure name is not working in PostgresSQL database.

Steps to reproduce :

1.Connect PostgresSQL server

2.Expand any database node then select schema node.

3.Expand schema node then select procedure

4.Select created procedure then right click on procedure

5.Select Alter procedure option. Procedure window opened successfully.

6.Change Procedure name then Switch to preview tab Alter script generated successfully

7.Alter scripts created extra (")double quotes in script.

8.Click on Alter button Now Error message displayed "ERROR: zero-length delimited identifier at or near """"

Position: 16".

All Comments (3) Change History

JennyNishimura 2017-07-26T03:28:45Z

The fix for issue #11314 resolved this issue, too.

raghavsingh 2017-07-31T04:39:29Z

Verified in ADS-19.0.beta-26. Refer screenshot 'Updated_10192.png'

tariqrahiman 2017-07-31T15:53:41Z

Verified in ADS v19.0.0-beta-27