Start a new topic

DBVis 9.2.13 - editing PostgreSQL array column in table view, cast error

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

Hi there, When I attempt to edit a PostgreSQL array column, using the data table view and editing the cell inline, the save fails, with an error saying to cast the expression.. However, copying the query and running it manually via the SQL Commander window works fine. e.g. given a table "MyTable" with a column "tags" with DDL "tags CHARACTER VARYING[]", this SQL is generated: UPDATE "public"."MyTable" SET "tags" = '{"Tag1","Tag2","Tag3"}' WHERE "id" = 1 Error: org.postgresql.util.PSQLException: ERROR: column "tags" is of type character varying[] but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 40

[This reply is migrated from our old forums.]

Re: DBVis 9.2.13 - editing PostgreSQL array column in table view, cast error
Hi Laurence, Unfortunately, it is not currently possible to edit array values in a Data or Result Set grid. I have opened a ticket for looking into this. In the meantime, you need to use SQL statements in an SQL Commander tab. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: DBVis 9.2.13 - editing PostgreSQL array column in table view, cast error
Hi Laurence, We just launched the BETA testing of the upcoming 9.5 version. One improvement is that arrays now can be updated in the table data editor. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger

Hi Laurence,


I just wanted to let you know that we have released DbVisualizer 9.5 today with support for the feature you asked for. Please upgrade to the latest official version. Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade.


An alternative is that you download from our web site: 


http://www.dbvis.com/download/


Best Regards,

Hans