Problem with dollar quoting

dev_gfkisl · Post by **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,

Pinturiccio · Post by **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.

dev_gfkisl · Post by **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

Best Regards

Pinturiccio · Post by **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.