title: Cannot alter composite type because a column is using it
body: <p>I am trying to alter the attributes of a composite type that is currently being used by a column in a table.</p>
  
  <p>I am using the command:</p>
  
  <pre><code>ALTER TYPE *typeName* ALTER ATTRIBUTE *attributeName* SET DATA TYPE text;
  </code></pre>
  
  <p>Unfortunately, I am getting the error:</p>
  
  <pre><code>ERROR:  cannot alter type *typeName* because column *columnName* uses it
  </code></pre>
  
  <p>How would I go about doing this in a production environment? Thanks!</p>