Unterminated dollar quoted string

Unterminated dollar quoted string

Postby 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?
a_balazs
 
Posts: 3
Joined: Sat 23 Nov 2013 11:06

Re: Unterminated dollar quoted string

Postby 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

Postby 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/postgresql/download.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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Unterminated dollar quoted string

Postby a_balazs » Sat 22 Feb 2014 09:31

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


Return to dotConnect for PostgreSQL