Problem executing PgSqlScript for creating postgres sql function

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
juju
Posts: 3
Joined: Sun 08 Nov 2015 18:42

Problem executing PgSqlScript for creating postgres sql function

Post by 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.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Problem executing PgSqlScript for creating postgres sql function

Post by 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: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Problem executing PgSqlScript for creating postgres sql function

Post by 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.

juju
Posts: 3
Joined: Sun 08 Nov 2015 18:42

Re: Problem executing PgSqlScript for creating postgres sql function

Post by juju » Wed 11 Nov 2015 23:41

this sounds great.
i'am waiting for the new version.
many thanks for your support.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Problem executing PgSqlScript for creating postgres sql function

Post by 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/postgr ... nload.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

Post Reply