search

microsoft / azuredatastudio-postgresql

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

Materialised view #499

Open craftzneko opened 4 months ago

craftzneko commented 4 months ago

Type: Bug

Unable to script to create on an existing materialised view. My view should look like this

CREATE MATERIALIZED VIEW ictsignal_lastscanperdevice AS
SELECT main.*
FROM ictsignal_production.ictsignal AS main
INNER JOIN (
    SELECT computername, MAX(datecreated) AS max_datecreated
    FROM ictsignal_production.ictsignal
    GROUP BY computername
) AS subquery ON main.computername = subquery.computername AND main.datecreated = subquery.max_datecreated;

but i get an error

image

Extension version: 0.6.0 Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i7-11800H @ 2.30GHz (16 x 2304)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|63.73GB (46.72GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
craftzneko commented 3 months ago

any update on this, i cant really use this plugin for my needs as i cant seem to see my views