Unterminated dollar quoted string

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
a_balazs
Posts: 3
Joined: Sat 23 Nov 2013 11:06

Unterminated dollar quoted string

Post by a_balazs » Thu 13 Feb 2014 14:48

Hello all,
My problem is that if I write an inline function in postgres, and try to execute in pgscript, I get the "unterminated dollar qouted string" exception:

Code: Select all

do
$tmp$
begin
if not exists(select setting_num from main.system_settings where setting_name='download_rates_mnb') then
 insert into main.system_settings(setting_name,setting_num,setting_display) values ('download_rates_mnb',1,'SOAP');
end if;
end
$tmp$
language plpgsql;
Any idea?

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Unterminated dollar quoted string

Post by MariiaI » Fri 14 Feb 2014 12:54

Thank you for the report. We have reproduced this issue. We will investigate it and inform you about the results as soon as any are available.
As a workaround, please execute your function via PgSqlCommand instead of PgSqlScript.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Unterminated dollar quoted string

Post by MariiaI » Wed 19 Feb 2014 08:08

The bug with executing anonymous code blocks in PgSqlScript is fixed.
New build of dotConnect for PostgreSQL 7.2.103 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 active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=28965.

a_balazs
Posts: 3
Joined: Sat 23 Nov 2013 11:06

Re: Unterminated dollar quoted string

Post by a_balazs » Sat 22 Feb 2014 09:31

Thank you

Post Reply