{"id":610,"date":"2005-09-19T00:00:00","date_gmt":"2005-09-18T22:00:00","guid":{"rendered":"https:\/\/wwwneu.strehle.de\/tim\/weblog\/archives\/2005\/09\/19\/545\/"},"modified":"2005-09-19T00:00:00","modified_gmt":"2005-09-18T22:00:00","slug":"545","status":"publish","type":"post","link":"https:\/\/www.strehle.de\/tim\/weblog\/archives\/2005\/09\/19\/545\/","title":{"rendered":"PostgreSQL Gotchas"},"content":{"rendered":"<p><a href=\"http:\/\/sql-info.de\/postgresql\/postgres-gotchas.html\" title=\"sql-info.de: PostgreSQL Gotchas - Postgres Gotchas\">PostgreSQL Gotchas<\/a>:<\/p>\n<p>\u201cPostgreSQL is a fully-featured, robust open-source database with strong SQL standards compliancy. As with all RDBMS products it has its odd little idiosyncracies, which while documented, are not obvious, counter-intuitive or just head-scratchingly odd.\u201d<\/p>\n<p>I\u2019ve already run into some of the problems described there &#8211; \u201cunquoted object names fold to lower case&#8220;, and \u201cCOUNT(*) very slow&#8220;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL Gotchas: \u201cPostgreSQL is a fully-featured, robust open-source database with strong SQL standards compliancy. As with all RDBMS products it has its odd little idiosyncracies, which while documented, are not obvious, counter-intuitive or just head-scratchingly odd.\u201d I\u2019ve already run into some of the problems described there &#8211; \u201cunquoted object names fold to lower case&#8220;, and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_share_on_mastodon":"0"},"categories":[1],"tags":[],"class_list":["post-610","post","type-post","status-publish","format-standard","hentry","category-weblog"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":0,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strehle.de\/tim\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}