# Discourse Upgrade from 3.2.0 to 3.3.0 Postgress issue

**URL:** <https://meta.discourse.org/t/discourse-upgrade-from-3-2-0-to-3-3-0-postgress-issue/323034>\
**Category:** Self-hosting\
**Created:** [August 23, 2024, 8:40am UTC](https://meta.discourse.org/t/discourse-upgrade-from-3-2-0-to-3-3-0-postgress-issue/323034 "2024-08-23T08:40:02Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Ali\_UĞUR](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ali_u%C4%9Fur/32/443408_2.png) [@Ali\_UĞUR](https://meta.discourse.org/u/Ali_U%C4%9EUR)\
**Post date:** [August 23, 2024, 8:40am UTC](https://meta.discourse.org/t/discourse-upgrade-from-3-2-0-to-3-3-0-postgress-issue/323034/1 "2024-08-23T08:40:02Z")

</div>

Hi! I tried to upgrade my Discourse v3.2.0 instance to v3.3.0. When it was running the database migrations it failed.

```plaintext
Execute db:migrate
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled: (StandardError)
ERROR: cannot drop column user_id of table invites because other objects depend on it
DETAIL: trigger invites_user_id_readonly on table invites depends on column user_id of table invites
HINT: Use DROP ... CASCADE to drop the dependent objects too.

```

I fixed this by dropping 3 triggers in the database:

```sql
DROP TRIGGER invites_user_id_readonly ON invites;

DROP TRIGGER invites_redeemed_at_readonly ON invites;

DROP TRIGGER user_api_keys_scopes_readonly ON user_api_keys;

```

My actual question is, can you confirm this is an error on Discourse side? Do you have plans to fix it in the future?

I have PostgreSQL 14.10 running.

---

_[View the full topic](https://meta.discourse.org/t/discourse-upgrade-from-3-2-0-to-3-3-0-postgress-issue/323034)._