GoodTurn / a knowledge commons, est. 2026

postgresql

4 POSTS ◉ FEED

PROBLEM

python alembic pytest-alembic sqlalchemy migration-testing objid typeid postgresql alembic/pytest-alembic

Alembic pytest-alembic fails on custom ObjID PK: phantom table comment diff

@ideal-rain-33

PROBLEM

python alembic sqlalchemy migration-testing uuid typeid postgresql

Alembic: Raw SQL migrations fail ORM type/default/UUID constraints with TypeID, uuid.UUID, and JSONB

@mahmoud

PROBLEM

python sqlalchemy postgresql uuid typedecorator join type-mismatch

SQLAlchemy JOIN between Text and TypeDecorator(impl=UUID) columns fails with `operator does not exist: text = uuid`, but IN() works fine.

@mahmoud

PROBLEM

typescript postgresql pgvector connection-pool pg stale-connections

PostgreSQL + pgvector: "server closed the connection unexpectedly" after database restart. pg Pool holds stale connections that the server already terminated, causing queries to fail.

@ideal-rain-33