| Author |
Message |
LonelyWalker
Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation |
|
 SA 7.3.430 SQL Editor bug on Postgres |
 |
In SA SQL Editor v4.3.430 cannot execute any code. Target configured as PostgreSQL 9.1. For example, code
 |
 |
create or replace function test()
returns void as
$$
begin
return;
end;
$$ language plpgsql;
|
failed with errors
|
|
Executing selected queries... Please wait or close this tab to cancel execution.
Code 7, State 42601, ERROR: unterminated dollar-quoted string at or near "$$ begin return; end;"
Code 7, State 42601, ERROR: unterminated dollar-quoted string at or near "$$ language plpgsql"
The command(s) completed with errors (1.40 ms).
|
In 7.2.338 everything is OK!
|
|
| Sun Oct 18, 2015 2:27 pm |
  |
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
Thank you very much for your feedback. We are investigating this issue.
|
|
| Sun Oct 18, 2015 9:28 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
This issue is going to be fixed in the next build, hopefully posted tomorrow to public downloads section
|
|
| Mon Oct 19, 2015 10:24 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
This bug has been fixed in the latest released build 7.4.433. Please update your install to that or a later version.
|
|
| Thu Oct 22, 2015 12:41 pm |
|
|
LonelyWalker
Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation |
|
| SA 7.4.435 SQL Editor bug on Postgres |
|
SA 7.4.435 SQL Editor: for one function everything is OK, but in batch
|
|
create or replace function boo()
returns void
as $$
begin
return;
end;
$$ language plpgsql;
grant execute on function boo() to public;
create or replace function foo()
returns void
as $$
begin
return;
end;
$$ language plpgsql;
grant execute on function foo() to public;
|
Error:
|
|
Executing selected queries... Please wait or close this tab to cancel execution.
0 rows affected.
0 rows affected.
Code 7, State 42601, ERROR: unterminated dollar-quoted string at or near "$$ begin return; end;"
Code 7, State 42601, ERROR: unterminated dollar-quoted string at or near "$$ language plpgsql"
Code 7, State 42883, ERROR: function foo() does not exist
The command(s) completed with errors (6.90 ms).
|
If you try to execute only one create + grant, it'll success...
|
|
| Wed Jan 20, 2016 12:04 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
Thank you so much for reporting this issue. I have logged it in our bug tracking system.
|
|
| Wed Jan 20, 2016 1:41 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
It appears that a fix for this bug is already available and it's pending version 7.5 release scheduled for the end of this month.
|
|
| Thu Jan 21, 2016 1:27 am |
|
|
LonelyWalker
Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation |
|
| |
|
Oh, thanx!
And what about Postgres 9.5 release support? It doesn't work in pgAdmin 1.22 (connection is okay):
|
|
| Mon Jan 25, 2016 11:23 am |
|
|
LonelyWalker
Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation |
|
| |
|
Well, I was able to make friends pgAdmin III 1.22 and SQL Assistant 7.4.435 after several re-installation (I don't know what has helped). But the error is still repeated:
 |
|
Unsupported window class (WxWindowClassNR) |
|
|
| Mon Jan 25, 2016 4:54 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
Support for latest pgAdmin versions is going to be available in 7.5 maintenance release, expected next week :-)
|
|
| Mon Jan 25, 2016 5:03 pm |
|
|
|
