{"id":385,"date":"2008-06-16T21:47:43","date_gmt":"2008-06-17T05:47:43","guid":{"rendered":"http:\/\/www.chesnok.com\/daily\/2008\/06\/16\/drupal-postgresql-review-some-patches-folks\/"},"modified":"2012-03-26T02:56:30","modified_gmt":"2012-03-26T10:56:30","slug":"drupal-postgresql-review-some-patches-folks","status":"publish","type":"post","link":"https:\/\/www.chesnok.com\/daily\/2008\/06\/16\/drupal-postgresql-review-some-patches-folks\/","title":{"rendered":"Drupal + PostgreSQL: review some patches, folks!"},"content":{"rendered":"<p><center><a href='http:\/\/www.flickr.com\/photos\/majorvols\/2537026948\/in\/photostream' title='baseball bat'><img src='http:\/\/www.chesnok.com\/daily\/wp-content\/uploads\/2008\/06\/2537026948_23fbc1c5a7.jpg' alt='baseball bat' height=\"300px\" \/><\/a><br \/><font size=\"-2\">am i the girl, the bat or the heart? you decide!<\/font><\/center><\/p>\n<p>I&#8217;ve been working on <a href=\"http:\/\/pugs.postgresql.org\/\">a site<\/a> that uses Drupal for a few months now. And I&#8217;m living dangerously with CCK, Views and, as of last week, Organic Groups.<\/p>\n<p>I found this <a href=\"http:\/\/drupal.org\/project\/modr8\">sharp moderation module (Modr8)<\/a> last week, and then quickly realized that I wanted to be able to provide this moderation tool any conferences that wanted it! Enter the Organic Groups.<\/p>\n<p>I&#8217;m using PostgreSQL for the back-end database, and so I&#8217;m used to being a second-class database citizen in Druplandia.  This means that I frequently have to patch modules so that they use SEQUENCE instead of AUTO_INCREMENT, or get rid of the (8) after an INT type.  So, when Organic Groups and the og_modr8 modules caused <a href=\"http:\/\/drupal.org\/node\/128846\">this bug<\/a> to rear up, and I suddenly had a full-scale &#8220;blogs running backwards&#8221; problem on my hands, I wasn&#8217;t surprised. <\/p>\n<p>Thank goodness for Brenda Wallace&#8217;s <a href=\"http:\/\/drupal.org\/node\/128846#comment-884840\">patch<\/a>, which fixed everything up a short while later.  What got me, however, was that the problem has had a fix (although not Brenda&#8217;s ultimate patch) for over a year, but it hasn&#8217;t been added to core. Particularly when the problem causes nodes to be presented out of order, site-wide.  <\/p>\n<p>Apparently there&#8217;s a shortage of PostgreSQL reviewers in the Drupal community.<\/p>\n<p>Fortunately, if you&#8217;d like to help get patches applied to core, there&#8217;s a page of <a href=\"http:\/\/groups.drupal.org\/node\/6980\">Patches To Be Reviewed<\/a>, and a few <a href=\"http:\/\/groups.drupal.org\/node\/9103#comment-28376\">people are trying to add a postgresql tag<\/a> to bugs.  If you&#8217;re a Drupaler and use PostgreSQL, please take a few minutes to review a patch.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>am i the girl, the bat or the heart? you decide! I&#8217;ve been working on a site that uses Drupal for a few months now. And I&#8217;m living dangerously with CCK, Views and, as of last week, Organic Groups. I &hellip; <a href=\"https:\/\/www.chesnok.com\/daily\/2008\/06\/16\/drupal-postgresql-review-some-patches-folks\/\">Continue reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,97,9],"tags":[124,644,123,647,624,125,122],"class_list":["post-385","post","type-post","status-publish","format-standard","hentry","category-drupal","category-postgres","category-postgresql","tag-5x","tag-drupal","tag-patching","tag-postgres","tag-postgresql","tag-srsly","tag-tough-love"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=385"}],"version-history":[{"count":1,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/385\/revisions"}],"predecessor-version":[{"id":4025,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/385\/revisions\/4025"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}