title: Can't write at all to Aurora PostgreSQL database
body: <p>I am trying to migrate an existing Rails application from a PostgreSQL RDS instance to Aurora PostgreSQL Serverless v2. I have created a new database for Aurora PostgreSQL Serverless v2 and successfully ran AWS DMS to migrate data.</p>
  <p>However, I am now facing a ton of &quot;null value in column x&quot; errors even for basic WRITE statements:</p>
  <pre><code>dev=&gt; INSERT INTO bots (name) VALUES ('hello world');
  ERROR:  null value in column &quot;id&quot; of relation &quot;bots&quot; violates not-null constraint
  DETAIL:  Failing row contains (null, hello world, null, null, null, null, null).
  db=&gt; exit
  </code></pre>
  <p>This happens when writing to literally any table.</p>
  <p>Is this related to a faulty migration of some sort? I wasn't connected to the source db at all during the duration of the migration, so I can't wrap my head around what may be causing this.</p>
  <p>The closest thing I've been able to find related to this is <a href="https://aws.amazon.com/premiumsupport/knowledge-center/dms-error-null-value-column/" rel="nofollow noreferrer">https://aws.amazon.com/premiumsupport/knowledge-center/dms-error-null-value-column/</a>, but I have used &quot;Limited LOB&quot; in the migration task. I think I'm going down the wrong path with the troubleshooting process.</p>