<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On 14 May 2007, at 8:23 PM, Barry Jaspan wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">As an example, the first mismatched table is aggregator_feed.<SPAN class="Apple-converted-space"> </SPAN>The</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">comparison report translates as: "Table aggregator_feed has a column</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">named 'description'.<SPAN class="Apple-converted-space"> </SPAN>hook_schema for this table says the column has</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">no default value but the actual database column has a default value of</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">''."<SPAN class="Apple-converted-space"> </SPAN>Sure enough, if you look at the mysql and pgsql CREATE TABLE</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">statements, you will see that mysql's (which is what was used to</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">create the "declared" structure) has no default while pgsql's (which</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">is what was used to create the "actual" structure) has one.</FONT></P> </BLOCKQUOTE></DIV><BR><DIV>It's late, and my memory is a bit spotty right now, but </DIV><DIV>iirc If you don't specify a default value in postgres, if you make a query , it will cause the query to fail.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>The default is basically like a 'required'.</DIV><DIV><BR class="khtml-block-placeholder"></DIV></BODY></HTML>