search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
196 stars 37 forks source link

Unable to update a PostgreSQL UUID type inline #281

Closed danieltskv closed 9 months ago

danieltskv commented 3 years ago

Issue Type: Bug

I have a PostgreSQL table, where one of the values is a UUID type. If I select "Edit Data" for that table, and try to manually change a value for that field, I get the error:

[Error - 2:34:44 PM] Request edit/commit failed.
  Message: can't adapt type 'UUID'
  Code: 0

If I try with a query command, such as this, it works:

UPDATE table_name
SET field = '00000000-0000-0000-0000-000000000000';

Thank you.

Extension version: 0.2.7 Azure Data Studio version: azuredatastudio 1.29.0 (0f5cfdc2c8c2433028842e16dc5ac1a65da24292, 2021-05-15T01:09:31.644Z) OS version: Darwin x64 20.5.0

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz (16 x 2300)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
protected_video_decode: unavailable_off
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|2, 2, 3| |Memory (System)|32.00GB (4.73GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
nasc17 commented 1 year ago

Please update to latest stable release of PostgreSQL extension v0.5.0 and Azure Data Studio v1.45.1. We would appreciate your verification if this issue is still present, thank you.

nasc17 commented 9 months ago

Please update to latest stable release of PostgreSQL extension v0.6.0 and Azure Data Studio v1.47.0. Reopen if this issue is still present, thank you.