On 14 May 2007, at 8:23 PM, Barry Jaspan wrote:

As an example, the first mismatched table is aggregator_feed.  The

comparison report translates as: "Table aggregator_feed has a column

named 'description'.  hook_schema for this table says the column has

no default value but the actual database column has a default value of

''."  Sure enough, if you look at the mysql and pgsql CREATE TABLE

statements, you will see that mysql's (which is what was used to

create the "declared" structure) has no default while pgsql's (which

is what was used to create the "actual" structure) has one.


It's late, and my memory is a bit spotty right now, but 
iirc If you don't specify a default value in postgres, if you make a query , it will cause the query to fail.

The default is basically like a 'required'.