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
Region-access support requests for PostgreSQL Flexible Server are stuck in an AI triage loop
As an Azure MVP, I want to flag a real gap I just hit firsthand. I opened a support ticket (Issue type: Service and subscription limits (quotas), Quota type: Region access) because a subscription of ours couldn't provision Azure Database for PostgreSQL Flexible Server in East US — az postgres flexible-server list-skus --location eastus returns "Provisioning is restricted in this region... open a support request with Issue type of 'Service and subscription limits'", exactly as documented. Over 9 days, I got three AI-generated responses (case #2608260040010469), all repeating the exact same generic instructions I had already followed and explicitly confirmed I'd followed — twice. No human engineer was ever assigned (confirmed via the Support API: supportEngineer: {} the entire time). The case was even auto-flagged for closure citing "no response," despite an active reply from me on record before that message was sent. This isn't a one-off complaint about response speed — it's a structural problem: region-access requests for this service appear to route through an automation loop that can't recognize "I already did what you're asking" and doesn't have a reliable escalation path to a human, even after an explicit "I'm still having an issue" signal. Has anyone else hit this on region-access requests specifically? And is there a known way to get these routed to an actual engineer instead of restarting the same script every 24-48h?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 https://github.com/arkhipov/temporal_tables. 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
Prevent Accidental Deletion of an Instance in Azure Postgres
Did you know that accidental deletion of database servers is a leading source of support tickets? Read this blog post to learn how you can safeguard your Azure Database for PostgreSQL Flexible Server instances using ARM’s CanNotDelete lock — an easy best-practice that helps prevent accidental deletions while keeping regular operations seamless. 🌐 Prevent Accidental Deletion of an Instance in Azure PostgresUnhandled 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?
