Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
[x] I have searched budibase discussions and github issues to check if my issue already exists
Hosting
Self
Method: docker single image
Budibase Version: 2.24.1
Describe the bug
When user is creating a table in postgreSQL from Budibase the autogenerated field "id" is not displaying any value eventhougt the field is populated in postgreSQL :
On Budibase :
Even a calculated column with content {{ id }} won't display anything
On the Postgre database :
column id is correctly created as primary key :
Postgre database is Azure Database for PostgreSQL
To Reproduce
Steps to reproduce the behavior:
Create a table in a postgre database. The id is not displayed
Expected behavior
The id should be displayed
Desktop (please complete the following information):
OS: windows
Browser: all browsers
Additional context
This problem is urgent as we need our user to see the id to communicate internally
Checklist
Hosting
Describe the bug When user is creating a table in postgreSQL from Budibase the autogenerated field "id" is not displaying any value eventhougt the field is populated in postgreSQL :
On Budibase :![image](https://github.com/user-attachments/assets/fdfdfbb7-acee-4924-88fe-03b05af59239)
Even a calculated column with content {{ id }} won't display anything![image](https://github.com/user-attachments/assets/5d85053f-c710-4e6a-ab46-0a3aab2aea64)
On the Postgre database :![image](https://github.com/user-attachments/assets/8f3b00d1-da44-4a61-871b-c8371d563b21)
column id is correctly created as primary key :![image](https://github.com/user-attachments/assets/f35bf76d-eabf-41ab-9572-8a1d0eaf7584)
Postgre database is Azure Database for PostgreSQL
To Reproduce Steps to reproduce the behavior: Create a table in a postgre database. The id is not displayed
Expected behavior The id should be displayed
Desktop (please complete the following information):
Additional context This problem is urgent as we need our user to see the id to communicate internally