microsoft / azuredatastudio-postgresql

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

Script As Create Fails #330

Closed alnoel closed 1 year ago

alnoel commented 2 years ago

Issue Type: Bug

Attempts to execute "Script as Create" fail.

DBMS: PostgreSQL 14 ADS:

Version: 1.39.0 (user setup) Commit: 9fdb2161d49b4d4ab6798809faa042a898ca2eae Date: 2022-08-20T01:46:47.606Z VS Code: 1.62.0 Electron: 13.6.6 Chrome: 91.0.4472.164 Node.js: 14.16.0 V8: 9.1.269.39-electron.0 OS: Windows_NT x64 10.0.19044

OS:

Edition Windows 10 Pro Version 21H2 Installed on ‎6/‎18/‎2020 OS build 19044.1889 Experience Windows Feature Experience Pack 120.2212.4180.0

Extension:

PostgreSQL v0.2.7

Error Message (there some column no longer available in the DBMS to be queried?)

"It seems the debugger cannot resolve C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\ntpath.py This may make the debugger miss breakpoints in the standard library. Related bug: https://bugs.python.org/issue1180193 [Error - 8:35:20 AM] Request scripting/script failed. Message: column rel.relhasoids does not exist LINE 8: pg_get_userbyid(rel.relowner) AS relowner, rel.relhasoids, " ^

Extension version: 0.2.7 Azure Data Studio version: azuredatastudio 1.39.0 (9fdb2161d49b4d4ab6798809faa042a898ca2eae, 2022-08-20T01:46:47.606Z) OS version: Windows_NT x64 10.0.19044 Restricted Mode: No

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i3-8100T CPU @ 3.10GHz (4 x 3096)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
rasterization: enabled
skia_renderer: enabled_on
video_decode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|31.83GB (22.92GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
DaeunYim commented 1 year ago

Tracking from https://github.com/microsoft/azuredatastudio-postgresql/issues/225. Closing the issue