title: Update a text column that contains a newline character '\n'
body: <p>I'm encountering weird behaviour of PostgreSQL where I try to run the following query</p>
  
  <pre><code>update posts 
  set content = replace(content, '\n', '&lt;br&gt;') 
  where content is not null;
  </code></pre>
  
  <p>and it's not doing anything to the data in the database. I **tried committing manually (including trying to run this query from psql) ** as well as setting DBeaver/pgAdmin to AUTOCOMMIT but to no avail.</p>
  
  <p>The result tells me <strong>37 rows have been updated, but the changes are not there</strong>. If I try to commit it tells me 0 rows affected.</p>
  
  <p>I have no triggers at all, so that's out of the question. </p>
  
  <p>Am I missing something here?</p>