sqlalchemy.exc.ProgrammingError: (psycopg2.errors.SyntaxError) type modifier is not allowed for type "text" 18 LINE 6: error TEXT(65535),

Open haripriyacv opened this issue 7 months ago • 1 comments

Querybook versions: 3.32.0 and 3.41.4 Database: Postgresql Deployment: Kubernetes deployment through Helm chart

When using postgresql database, getting the below error and application fails to start. sqlalchemy.exc.ProgrammingError: (psycopg2.errors.SyntaxError) type modifier is not allowed for type "text" 18 LINE 6: error TEXT(65535),

To resolve these errors, I had to modify the files under querybook/querybook/migrations/versions and change sa.Text(65536) to sa.Text() and rebuild the image.

May 22 '25 06:05 haripriyacv

Any plans to correct this in coming release, so postgresql connectivity is seamless?

May 28 '25 05:05 haripriyacv