[development] Reconciling mysql & pgsql schemas

[adrian rossouw]

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'.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070515/edd4e4e6/attachment.htm