Problem with dollar quoting

Problem with dollar quoting

Postby dev_gfkisl » Tue 10 Apr 2012 13:58

Hello,
I use dotConnect for PostgreSQL 5.80.332 with Postgres version 8.2 and 9.1

When I execute the following query, I have an error message.

UPDATE mytextfield=$$0000$$

Error Message :
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

But if I execute the same query with pgAdmin, I haven't problem.

Best Regards,
dev_gfkisl
 
Posts: 2
Joined: Tue 10 Apr 2012 13:08

Postby Pinturiccio » Wed 11 Apr 2012 09:20

We could not reproduce the issue. A dollar-quoted string works fine with PostgreSQl 8.2 and 9.1 when used with dotConnect for PostgreSQL. Could you please post here the whole command text and DDL/DML scripts for reproducing the issue? We would also appreciate a small test project.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Postby dev_gfkisl » Wed 11 Apr 2012 10:28

Hello,

You can use the demo for reproduce this problem.
Please find 2 screenshots, the both request are OK with pgAdmin

Image
Image

Best Regards
dev_gfkisl
 
Posts: 2
Joined: Tue 10 Apr 2012 13:08

Postby Pinturiccio » Wed 11 Apr 2012 11:43

We still cannot reproduce the issue.
Please send us the DDL/DML scripts for your tables, so that we could use your queries.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL