January 25, 2014

Fixing up a referential integrity issue

Earlier today, I wrote about a fix which broke search. At the end of that post, I mentioned a few things which needed to be done to fix up the broken relationships. clean up the database add a foreign key, on delete set null trigger to find the right value when set null Let’s get […]

Fixing up a referential integrity issue Read More »

Bad SQL corrupts search results

Leave a Comment / Bug fixes, PostgreSQL / Dan Langille

Bernard emailed me, and Tim Stoddard posted in the forum about search not finding what it should find. I quickly agreed; it was wrong. Fortunately, it was a small fix. See also my follow-up post where I fixed the broken data. The problem The problem was searching for ports such as bird didn’t include that

Bad SQL corrupts search results Read More »