[development] Reconciling mysql & pgsql schemas

Barry Jaspan barry at jaspan.org
Tue May 15 11:59:51 UTC 2007


adrian rossouw <adrian at bryght.com> writes:
> 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'.

I'm not sure if you are saying (a) that specifying a default value in
CREATE TABLE is required or (b) that if you specify a default value in
CREATE TABLE then all subsequent INSERTs into that table will require
that you specify the default value or (c) something else.

When you wake up, please clarify. :-)

Barry



More information about the development mailing list