PostgreSQL does not allow ordering by columns not included in the SELECT list when using SELECT DISTINCT, while SQLite handles this automatically.
Fixed
Fixed the issue where PostgreSQL could not use get_chat_ids_by_model_id
Contributor License Agreement
By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.
Note
Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in.
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/open-webui/open-webui/pull/21351
**Author:** [@EntropyYue](https://github.com/EntropyYue)
**Created:** 2/13/2026
**Status:** ❌ Closed
**Base:** `dev` ← **Head:** `fix/chat-messages`
---
### 📝 Commits (1)
- [`646101d`](https://github.com/open-webui/open-webui/commit/646101d0c91d5ef48bd679efeefdc1acc985ea72) fix: PostgreSQL cannot use get_chat_ids_by_model_id
### 📊 Changes
**1 file changed** (+14 additions, -9 deletions)
<details>
<summary>View changed files</summary>
📝 `backend/open_webui/models/chat_messages.py` (+14 -9)
</details>
### 📄 Description
<!--
⚠️ CRITICAL CHECKS FOR CONTRIBUTORS (READ, DON'T DELETE) ⚠️
1. Target the `dev` branch. PRs targeting `main` will be automatically closed.
2. Do NOT delete the CLA section at the bottom. It is required for the bot to accept your PR.
-->
# Changelog Entry
### Description
- PostgreSQL does not allow ordering by columns not included in the SELECT list when using SELECT DISTINCT, while SQLite handles this automatically.
### Fixed
- Fixed the issue where PostgreSQL could not use get_chat_ids_by_model_id
### Contributor License Agreement
<!--
🚨 DO NOT DELETE THE TEXT BELOW 🚨
Keep the "Contributor License Agreement" confirmation text intact.
Deleting it will trigger the CLA-Bot to INVALIDATE your PR.
-->
By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](https://github.com/open-webui/open-webui/blob/main/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms.
> [!NOTE]
> Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in.
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/open-webui/open-webui/pull/21351
Author: @EntropyYue
Created: 2/13/2026
Status: ❌ Closed
Base:
dev← Head:fix/chat-messages📝 Commits (1)
646101dfix: PostgreSQL cannot use get_chat_ids_by_model_id📊 Changes
1 file changed (+14 additions, -9 deletions)
View changed files
📝
backend/open_webui/models/chat_messages.py(+14 -9)📄 Description
Changelog Entry
Description
Fixed
Contributor License Agreement
By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.