Menu
I have just installed pgadmin 4.9 and am trying to edit several fields in my existing database. I right-click the table, select "View/Edit data" -> "All rows". Then in my table I change the data in a field of type "Text". When I then press the "Save" button, I get
'int' object has no attribute 'replace'
Changing the field via an "Update" script works fine though.
Has anyone else experienced this?
This is on Windows 10 and pgadmin runs in MS Edge.
948
Use the Edit menu to search, replace, or navigate the code displayed in the SQL Editor: Select Find to provide a search target, and search the SQL Editor contents. Select Replace to locate and replace (with prompting) individual occurrences of the target.
To modify the displayed data: To change a numeric value within the grid, double-click the value to select the field. Modify the content in the square in which it is displayed. To change a non-numeric value within the grid, double-click the content to access the edit bubble.
Select column, right click and choose Properties... option to open column editor. Alternatively select column in tree control and on Properties tab and open column editor with edit icon. In the editor update Comment field and confirm changes with Save button.
This was a bug in pgAdmin4 when updating table and PK is of integer type.
It is fixed now and it will be available in next release, meanwhile you can use nightly build as a workaround.
Download: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-07-01/
---- UPDATE ----
pgAdmin 4 v4.10 is released with the fix.
153
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
