operator does not exist: integer = uuid

[gmverdon]

In my view I have the following line of code:

chat.messages.unread_by(@current_identity).length

However this results into the following error:

ActionView::Template::Error (PG::UndefinedFunction: ERROR:  operator does not exist: integer = uuid
LINE 3:                AND "read_marks".readable_id    = "messages"....

My messages have UUID's. Is there support for UUID'S?

[ledermann]

You need to change the generated migration to use UUIDs.

[franzejr]

Even changing it, it seems the error persists...

[elduglas]

Even changing it, it seems the error persists...

Hi, I'm sorry for my bad english. My solution was delete the column sluggable_id from friendly_id_slugs and add again the column but as uuid.

  def change
    remove_column :friendly_id_slugs, :sluggable_id
    add_column :friendly_id_slugs, :sluggable_id, :uuid
  end

😃

[topgunjoe]

This issue was occurring in my case because the primary key field type was UUID, however, the foreign key field type was int.

The mistmatch was causing the error.