You can login if you already have an account or register by clicking the button below.
Registering is free and all you need is a username and password. We never ask you for your e-mail.
[–]logos_ethos0 points
2 points
2 points
(+2|-0)
ago
(edited ago)
@PuttItOut Use the citext extension (CREATE EXTENSION citext;) and citext data type if case insensitive matching is needed at the index or SQL level by default. Or use expression indexes with lower function (but you need this in every case insensitive query).
[–]PuttItOut0 points
3 points
3 points
(+3|-0)
ago
I don't remember what the reason was that we chose to not go with citext. There was some reason. I'm willing to look into this again but if I recall correctly there was a deal breaker.
@FuzzyWords, do your remember if you talked me out of this or I did that myself?
view the rest of the comments →
[–] logos_ethos 0 points 2 points 2 points (+2|-0) ago (edited ago)
@PuttItOut Use the citext extension (CREATE EXTENSION citext;) and citext data type if case insensitive matching is needed at the index or SQL level by default. Or use expression indexes with lower function (but you need this in every case insensitive query).
Here is a patch for the SQL files:
voat-citext.patch https://filetea.me/n3woeqSt4vKRregB0vXc0112g
Also, once you have applied that patch, you may want this one if you want time stored in absolute time / UTC instead of "wall clock time." See this: http://phili.pe/posts/timestamps-and-time-zones-in-postgresql/
voat-tz.patch: https://filetea.me/n3wtAeS205BTD6qDfR7WBxyLw
[–] logos_ethos 0 points 1 point 1 point (+1|-0) ago
Hi @PuttItOut
I am pinging you just to let you know that I fixed the citext patch link (I guess it expired) and added the tz patch if you want it.
[–] PuttItOut 0 points 3 points 3 points (+3|-0) ago
I don't remember what the reason was that we chose to not go with citext. There was some reason. I'm willing to look into this again but if I recall correctly there was a deal breaker.
@FuzzyWords, do your remember if you talked me out of this or I did that myself?