ActiveRecord::Enum - PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer:

Question

I am having a strange error and was hoping someone could point me in the right direction. I have a model called Organizations, and a attribute called department, see the excerpt from the schema below:

t.integer  "department",  default: 0

Inside my model have defined my enums for this attribute, as I am using ActiveRecord::Enum, like below:

enum department: [:conferences, :design_teams, :services, :clubs, :events, :communications]

But when I query, JobPosting.joins(job: :organization).where(organizations: { department: 'conferences' }) I get an error that reads:

PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "conferences"

FYI: An Organization has_many Jobs, and Job has_many JobPostings.

But when I query Organization.where(department: 'conferences') it works.

Any help would be greatly appreciated.

Adam Zapaśnik · Accepted Answer · 2017-03-29 08:42:20Z

4

This works on ror5.

JobPosting.joins(job: :organization).where(organizations: 
{ department: Organization.departments['conferences'] })

I'm not even sure if enum was available in ror3.

answered Mar 29, 2017 at 8:42

Adam Zapaśnik

6834 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Neeraj Over a year ago

In RoR 3 enum was not available.

AlexeyKuznetsov · Accepted Answer · 2017-03-29 21:28:08Z

1

Other way is to set text-based enums. In my opinion it is the best way for enum:

DEPARTMENTS_ENUM = [:conferences, :design_teams, :services, :clubs, :events, :communications]
enum department: Hash[*DEPARTMENTS_ENUM.collect{|v| [v, v]}.flatten()]

It will work after department column type will change.

Organization.where(department: 'conferences')

Will work too

answered Mar 29, 2017 at 21:28

AlexeyKuznetsov

4124 silver badges12 bronze badges

Comments

bormat · Accepted Answer · 2020-11-16 17:22:39Z

1

I am not directly answering the question but as it is the first link on google when we search PG::InvalidTextRepresentation: ERROR: invalid input value for enum

it can help:

it is possible to declare our enum like this, this way it will not convert the string to an integer but let this job to postgresql.

enum provider: { ig: "ig", fb: "fb", powertrack: "powertrack", gnip: "gnip" }

answered Nov 16, 2020 at 17:22

bormat

1,37913 silver badges16 bronze badges

Collectives™ on Stack Overflow

ActiveRecord::Enum - PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer:

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related