Description of problem:
When I installed FC2 test1 odbc access to Postgresql worked properly
ie: write access. Now for some reason only read access is allowed.
This seemed to happen after I did a query via odbc
I have tested the Database/odbc driver with excel/access and
everything works fine.
*** Bug 117190 has been marked as a duplicate of this bug. ***
What's your unixODBC rpm version ? Can you try with a unixODBC >= 2.2.8 ?
> su - postgres
Enter name of user to add: cmc
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
> su - cmc
cat > /etc/odbc.ini
Description = Postgres database test
ReadOnly = 0
Servername = localhost
Database = cmc
Port = 5432
Driver = PostgreSQL
Protocol = 7.4.6
UserName = cmc
> oowriter &
new data source, database type ODBC, select PostgreSQL-test
successfully add a table with some random column types
can view and edit database
create a simple query, can run it and can still edit afterwards
exit oowriter, restart, still ok
I suspect that it might have been a problem with unixODBC, I can't
reproduce a similiar problem on FC-3. Though if theres another way to
reproduce this, feel free to reopen.