Hi we are getting the following error

[devout scarab]

curl --location 'http://localhost:3476/v1/tenants/sennder/permissions/check' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--data '{
  "metadata": {
    "schema_version": "ci5dge672a32k53qfmtg",
    "depth": 3
  },
  "entity": {
    "type": "carrier",
    "id": "1"
  },
  "permission": "create_asset",
  "subject": {
    "type": "user",
    "id": "1"
  }
}'

the version we are using is v0.4.6

the is the log from datadog. one fact is that we have two permify instances connecting to the same postgresql database.

[glacial field]

Hello @devout scarab , which version of Postgres are you using?

[devout scarab]

the postgres is AWS managed instance with Engine version 14.6

looks like the max function in version 14 does not support xid8 type according to this page: https://www.postgresql.org/docs/14/functions-aggregate.html

[glacial field]

Is it possible for you to update your Postgres version? Or should we consider different solutions?

[devout scarab]

let me try it out

[glacial field]

Hello again, @devout scarab , could you try this version of Permify? https://github.com/Permify/permify/releases/tag/v0.4.7, v0.4.7.

This release includes:

• Subject Permission List: https://docs.permify.co/docs/api-overview/permission/subject-permission
• Distributed Cache Configuration: https://github.com/Permify/deployment-patterns/tree/main/distributed-deployment-serf
  You can find these in it, and the problem you mentioned should be resolved.

[devout scarab]

awesome! will try it. thanks.

[devout scarab]

Hi Tolga, just let you know that the issue has been solved with permify v0.4.7. I will try the Subject Permission List feature later on. thanks for your great support!