Page 1 of 1

error: can not modify a read-only dataset

Posted: Tue 28 Jan 2014 10:30
by douglasfabiano
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.

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

Posted: Wed 29 Jan 2014 09:18
by AlexP
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.

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

Posted: Fri 10 Apr 2015 14:40
by douglasfabiano
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

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

Posted: Tue 14 Apr 2015 09:50
by AlexP
You can use both pv20 and pv30 protocols with PostgreSQL 9.3.