error: can not modify a read-only dataset

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
douglasfabiano
Posts: 5
Joined: Mon 17 Sep 2012 23:24

error: can not modify a read-only dataset

Post by douglasfabiano » Tue 28 Jan 2014 10:30

hello,
UniDAC to use the connection delphi with PostgreSQL 9.2 on CentOS 5.4.
about 3 months ago is occurring the error can not modify a read-only dataset for new objects that are created in the database, only that server, using the same exe elsewhere, works without any problem.
After many tests, one of our colleagues changed ProtocolVersion = pv20 property and the error did not occur anymore.
I've been reading the documentation and found that such property is to maintain compatibility postgres 7.3 or lower.
This problem is due to some dll? For Postgresql used is one of the last available.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: error: can not modify a read-only dataset

Post by AlexP » Wed 29 Jan 2014 09:18

Hello,

We cannot reproduce the problem, we don't use client libraries to access PostgreSQL, we work with server directly via TCP/IP. You can use both the second and the third protocol versions to work with PostgreSQL.

douglasfabiano
Posts: 5
Joined: Mon 17 Sep 2012 23:24

Re: error: can not modify a read-only dataset

Post by douglasfabiano » Fri 10 Apr 2015 14:40

hello ..
again is with this problem in the unidac driver, and decided after re-we install postgresql.
utilizmaos the driver also in other of our system the dbexpress, and this is not the problem.
which reading is used to check the version of postgres to assign the ProtocolVersion?
we are using the postgres version 9.3 with centOS 6.4

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: error: can not modify a read-only dataset

Post by AlexP » Tue 14 Apr 2015 09:50

You can use both pv20 and pv30 protocols with PostgreSQL 9.3.

Post Reply