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
Further info 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. ***
caolanm->mike.uk: What's your unixODBC rpm version ? Can you try with a unixODBC >= 2.2.8 ?
openoffice.org-1.1.2-11.5.fc3 unixODBC-2.2.10-1 postgresql-7.4.6-1.FC3.1 > su - postgres > createuser 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 CREATE USER > exit > su - cmc > createdb CREATE DATABASE > su cat > /etc/odbc.ini [PostgreSQL-test] Description = Postgres database test ReadOnly = 0 Servername = localhost Database = cmc Port = 5432 Driver = PostgreSQL Protocol = 7.4.6 UserName = cmc Password = ^D > exit > oowriter & tools->data sources 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.