read only output of select

Hello, I use DbVisualizer 8.0.8 and have two select statements from which the first one only produces a read only result set, which I don't understand why. What is the difference between the two statements that the first one produces only read only results? select * from label_dokument where wert ~ E' +?'; select * from label_dokument where id in (4697, ...); Thanks.

Hi Thorsten, That seems odd. Please enable debugging and run the statement that gives you a read-only result set and post or mail us the log. Please see this FAQ for how to enable debugging: http://www.dbvis.com/products/dbvis/doc/faq/#4.14 Best Regards, Hans

Regarding the debug log the ~-character is the problem. I'm querying against a PostgreSQL 8.1.4 where this character should be allowed for regular expressions. 08:54:53 [DEBUG Thread-23 AbstractFacade.getColumn] executing "show search_path" 08:54:53 [DEBUG pool-2-thread-2 C.?] DefaultEditor-0: Jdbc4Connection.createStatement() 08:54:53 [DEBUG pool-2-thread-2 B.?] DefaultEditor-0: Jdbc4Statement.executeQuery("show search_path") 08:54:53 [DEBUG Thread-23 J.execute] Executing... 08:54:53 [DEBUG Thread-23 J.setCurrentCatalog] DbConnection='ams_lgxelrev_docbeam' Catalog='ams_lgxelrev_docbeam' Schema='null' NewCatalog='ams_lgxelrev_docbeam' 08:54:53 [DEBUG Thread-23 AbstractFacade.getColumn] executing "show search_path" 08:54:53 [DEBUG pool-2-thread-2 C.?] DefaultEditor-0: Jdbc4Connection.createStatement() 08:54:53 [DEBUG pool-2-thread-2 B.?] DefaultEditor-0: Jdbc4Statement.executeQuery("show search_path") 08:54:53 [DEBUG Thread-23 J.setCurrentSchema] DbConnection='ams_lgxelrev_docbeam' Catalog='null' Schema='public' NewSchema='public' 08:54:53 [DEBUG pool-2-thread-2 C.?] DefaultEditor-0: Jdbc4Connection.createStatement() 08:54:53 [DEBUG pool-2-thread-2 B.?] DefaultEditor-0: Jdbc4Statement.execute("select * from label_dokument where wert ~ E' +?'") 08:54:54 [DEBUG AWT-EventQueue-1 F.?] Editable dataset check failed: Unexpected token: '~' 08:54:54 [DEBUG AWT-EventQueue-1 F.?] Edit not allowed: Editable dataset check failed: Unexpected token: '~' 08:54:54 [DEBUG Thread-23 AbstractFacade.getColumn] executing "show search_path" 08:54:54 [DEBUG pool-2-thread-2 C.?] DefaultEditor-0: Jdbc4Connection.createStatement() 08:54:54 [DEBUG pool-2-thread-2 B.?] DefaultEditor-0: Jdbc4Statement.executeQuery("show search_path")

Hi Thorsten, Thanks for your help with this. You're right. It will be fixed in the next maintenance release. Best Regards, Hans