#14539: Why AutoCompletion is not working in Function Editor for PostgreSQL?

nishtha(*) reported 2016-07-12T10:17:22Z · niraj.pandey(*) last modified 2017-01-04T04:25:46Z

Why AutoCompletion is not working in Function Editor for PostgreSQL?

Dev	JennyNishimura
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	DB - PostgreSQL
Version	18.0

Product: Aqua Data Studio
Version: 18.0.0-devi-182
Build #: 50446
Build Date: 2016-Jul-10 09:50:39 PM

Operating Environment: Linux (4.4.0-28-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15
Memory: Max=704,643,072; Total=523,763,712; Free=323,366,696; CPUs=8

Steps to reproduce the issue :
1. Connect to PostgreSQL Server.
2. Go to Function tree node of any Database.
3. Right click on it and Select "Create Function in Editor" option.
4. A Simple Create Function script is generated in Editor.
5. In Function body write SELECT * FROM and hit 'Ctrl+Space' after it.

Actual Result :
Auto Complete pop-up does not appears in editor after FROM.

Expected Result :
Auto Complete pop-up should appear after pressing 'Ctrl+Space'.

Observation :
1. This issue is also observed V17.
2. Auto Completion works correctly in Function Editor for "Oracle" and "MS SQL Server" databases. (Issue#159 in IDEA)

Please refer attached screen-shot "AutoCompletion in Function Editor.png" and "AutoCompletion in SQL Server.png".

2 attachments

AutoCompletion in Function Editor.png

2016-07-12T10:17:22Z

138 KB
AutoCompletion in SQL Server.png

2016-07-12T10:17:22Z

87 KB

All Comments (4) Change History

SachinPrakash 2016-07-13T18:49:39Z

@jenny: for which DBs do we support auto-completion in package / procedure editors?

JennyNishimura 2016-07-13T23:06:26Z

For PostgreSQL, the syntax generated in the Function Editor is as follows:

CREATE FUNCTION "public"."fx_hello_world" (int, int) RETURNS bool AS
'
BEGIN
    IF $1 = 1 THEN
        RETURN TRUE;
    ELSE
        RETURN FALSE;
    END IF;
END
'
LANGUAGE 'plpgsql'

Notice that the function body is enclosed within single quotes. There is no auto-completion pop-up when the cursor is inside single quotes.

Try the following in the Query Analyzer window. ^ is the cursor position where you hit ctrl-space.

SELECT * FROM ^

The auto-completion pop-up appears with the list of tables.

Now enclose the SELECT statement in single quotes and hit ctrl-space at ^ again.

'SELECT * FROM ^'

The auto-completion pop-up doesn't appear.

For PostgreSQL, the syntax generated in the Function Editor is as follows:

CREATE FUNCTION "public"."fx_hello_world" (int, int) RETURNS bool AS
'
BEGIN
    IF $1 = 1 THEN
        RETURN TRUE;
    ELSE
        RETURN FALSE;
    END IF;
END
'
LANGUAGE 'plpgsql'

Notice that the function body is enclosed within single quotes. There is no auto-completion pop-up when the cursor is inside single quotes.

Try the following in the Query Analyzer window. ^ is the cursor position where you hit ctrl-space.

SELECT * FROM ^

The auto-completion pop-up appears with the list of tables.

Now enclose the SELECT statement in single quotes and hit ctrl-space at ^ again.

'SELECT * FROM ^'

The auto-completion pop-up doesn't appear.

nishtha(*) 2016-07-14T05:14:21Z

@Jenny : Thanks for the explanation.

niraj.pandey(*) 2017-01-04T04:25:35Z

Verified as per above explanation.So marking it 'Closed'.

Search Tips

Aqua Data Studio / nhilam

Why AutoCompletion is not working in Function Editor for PostgreSQL?

2 attachments

Issue #14539

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Why AutoCompletion is not working in Function Editor for PostgreSQL?

2 attachments

Issue #14539

Completion