Forum Widgets
Latest Discussions
Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
Is encoding SQL_ASCII with Collation en_US.1252 supported in Azure FlexibleServer PostgreSQL? CREATE DATABASE databaseforme WITH ENCODING = 'SQL_ASCII' LC_COLLATE = 'en_US.1252' LC_CTYPE = 'en_US.1252' IS_TEMPLATE = False; I am trying to create the database but I am getting the error: ERROR: invalid locale name: "en_US.1252" SQL state: 42809
PostgreSQL - Flexible Compute - VNet DNS Update
Hello, I have a customer planning to update the VNet DNS from custom to Default. The client is running a PostgreSQL - Flexible server with VNet integration. Does the DNS change impact PostgreSQL - Flexible compute? What is the best way to update the PostgreSQL - Flexible compute without having to restart? Thanks, Terru
What to do to add temporal_tables extension to the available extensions
Hi All, There is this limitation with postgresql extensions. We can use extensions only from the given list of available extensions. In our local (on-prem) environment we use temporal_tables extension of Vlad Arkhipov. What is the process of making a request to make available this extension in Azure Flexible server environment? Best regards, Csabaazure data studio "postgres unhandled exception while executing query: 'list' object has no attribut
I am using azure data studio and getting below error when executing the query " select * from pg_catalog.pg_proc" error : "azure data studio "postgres unhandled exception while executing query: 'list' object has no attribute 'encode'" I dont see this error in pgadmin or any psql client
Unhandled exception while executing query: 'list' object has no attribute 'encode'
Azure Studio: Version: 1.47.1 (user setup) Commit: b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e Date: 2024-01-10T02:15:02.628Z VS Code: 1.82.0 Electron: 25.8.4 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.19045 When running the below: select * from pg_database; I get: Please kindly assist Microsoft?Any performance impact after enable Query Store feature in Azure PostgreSQL DB Server
Hi Team, We want to enable Query store in Azure PostgreSQL DB server for Intelligent Performance (Query Performance Insight and Performance Recommendations) feature. Before enable the feature, want to understand any performance impact on the PostgreSQL DB server if enable the feature. Can you please share if you have any insight on the performance impact. Thanks in advance. Thanks Shaban Khan
