Postgresql: Field length for smart variables too small
I have a smart-parameter of type hash. I want to insert a default value that is longer than 255 characters. On submit, I get an error from the postgresdb, that lookup_keys.default_value is of type varying(255) and the value is too long. (The message is on german, so I can't give you the exact wording)
The same setup works, when I use sqlite as backend. It seems, as if the sqlite fields are defined as text, whereas the postgresql fields are defined as varying(255), which is definitely too short for me as I have right now hashes as parameters as long as 12996 characters.
BTW: Foreman is an absolutely astonishing piece of work!
ForemanVersion: 1.0.1-7 - RPM Package from 2012-11-21, devel-yum repository - everything installed via rpm
Platform: RedHat 6.3 x86_64
#1 Updated by Florian Sachs almost 9 years ago
I altered the column from "character varying(255)" to "text" and it worked. (didn't know about the text type until my dbadmin told me) I don't know exactly which columns are affected, but will keep track of them as I change them, so I will be able to provide information if the need arises.