Start a new topic

read only output of select

[This topic is migrated from our old forums. The original author name has been removed]

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.

[This reply is migrated from our old forums.]

Re: read only output of select
Thorsten, Just to inform you that this is now fixed in the 8.0.10 version. http://www.dbvis.com/download/ Regards Roger
[This reply is migrated from our old forums.]

Re: read only output of select
Hi Thorsten, Thanks for your help with this. You're right. It will be fixed in the next maintenance release. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: read only output of select
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")
[This reply is migrated from our old forums.]

Re: read only output of select
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