Please confirm that the bug report does not already exist

• I confirm there is no existing issue for this bug.

Steps to reproduce

Description:
I am using NocoDB connected to a Supabase (PostgreSQL) database. When I try to change a column type from SingleLineText to SingleSelect via the NocoDB UI, the operation fails if the underlying Postgres column has a DEFAULT value constraint set.

Steps to Reproduce:

1. Create a table in PostgreSQL (Supabase) via SQL:
   CREATE TABLE public.test_bug ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, status text DEFAULT 'DRAFT' );

2. Connect NocoDB to this database.

3. Open the test_bug table. The status column correctly shows as SingleLineText.

4. Click Edit Column on status.

5. Change Type to SingleSelect.

6. Add an Option (e.g., DRAFT).

7. Click Save.

Actual Behavior:
UI displays toast notification: Some internal error occurred.
The column remains as Text.

Desired Behavior

NocoDB should handle the existing DEFAULT constraint (either drop it or update it to match the new Enum logic) and successfully convert the column to SingleSelect.

Project Details

Node: v22.20.0
Arch: x64
Platform: linux
Docker: true
RootDB: sqlite3
PackageVersion: 0.265.1

Environment:
Database: PostgreSQL (Supabase)
Deployment: Coolify

Attachments

No response