[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