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

When trying "Script as Create" it won't work for PostgreSQL #321

Closed luqq closed 1 year ago

luqq commented 2 years ago

Right Clicking any table will show this log on output:

[Error - 02:17:43] Request scripting/script failed.
  Message: column rel.relhasoids does not exist
LINE 8:   pg_get_userbyid(rel.relowner) AS relowner, rel.relhasoids,
                                                     ^

  Code: 0 
[object Object]

It works just fine in SQL Server.

ADS version: 1.36.2 PostgreSQL plugin version: v0.2.7 PostgreSQL server version: postgres (PostgreSQL) 14.3 (Ubuntu 14.3-1.pgdg22.04+1)

It won't even work with _EFMigrationsHistory table image

Hope this helps! Thank you

DaeunYim commented 1 year ago

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