Problem executing PgSqlScript for creating postgres sql function

Problem executing PgSqlScript for creating postgres sql function

Postby juju » Sun 08 Nov 2015 18:57

i have a written a short postgres sql function.
this function can you find below:

CREATE FUNCTION "left"(text, integer) RETURNS text
LANGUAGE plpgsql
AS $_$
DECLARE
BEGIN
RETURN substr($1, 1, $2);
END;
$_$;


i used latest dotconnect for postgres
but unfortunately executing of pgsqlscript is not possible because of following error message:

Dollar-Quotes nicht abgeschlossen bei „$_$
DECLARE
BEGIN
RETURN substr($1, 1, $2)

in english:
dollar quotes not terminated !!!!

into program pgadmin i can run this function with out any problems.
juju
 
Posts: 2
Joined: Sun 08 Nov 2015 18:42

Re: Problem executing PgSqlScript for creating postgres sql function

Postby Pinturiccio » Mon 09 Nov 2015 13:06

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: Problem executing PgSqlScript for creating postgres sql function

Postby Pinturiccio » Wed 11 Nov 2015 11:10

We have fixed the bug with executing query in PgSqlScript containing function declarations. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: Problem executing PgSqlScript for creating postgres sql function

Postby juju » Wed 11 Nov 2015 23:41

this sounds great.
i'am waiting for the new version.
many thanks for your support.
juju
 
Posts: 2
Joined: Sun 08 Nov 2015 18:42

Re: Problem executing PgSqlScript for creating postgres sql function

Postby Pinturiccio » Fri 13 Nov 2015 09:34

New build of dotConnect for PostgreSQL 7.4.535 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32775
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL