[development] A little pgsql help

Piotr Krukowiecki piotr at mallorn.ii.uj.edu.pl
Mon Mar 13 19:09:12 UTC 2006


On Mon, Mar 13, 2006 at 08:04:10PM +0100, Piotr Krukowiecki wrote:
> mysql 4.1.11 - either the default is allways added (i.e. you can't specify 
> a column without a default) or if there is no default, the empty string
> is inserted:


http://dev.mysql.com/doc/refman/4.1/en/create-table.html
If a column definition includes no explicit DEFAULT value, MySQL
determines the default value as described in Section 11.1.4, \u201cData
Type Default Values\u201d.

And http://dev.mysql.com/doc/refman/4.1/en/data-type-defaults.html for
details.

The error is thrown with mysql 5.x in strict mode.


-- 
Piotrek
irc: #debian.pl
Mors Drosophilis melanogastribus!


More information about the development mailing list