pgsql: empty dates and bigints

[SaschaKoth]

Hi,

another little problem in pgsql driver.

When we use dates or bigints, empty values ('') causes Exceptions. This is because the framework interprets this types as strings and set this as db value.

1. bigint
   In pgsql\Schema.php an item on $typeMap for 'int8' is missing
2. date
   In db\Schema.php an item on $typeMap for 'date' is missing (in method getColumnPhpType($column)

Thanks
Sascha

[qiangxue]

I fixed the first one. I don't quite get the second issue. What are you suggesting to fix?

[SaschaKoth]

If you add 'date => 'date' for $typeMap in method getColumnPhpType($column) in db\Schema.php, the method typecast($value) in db/ColumnSchema.php would return 'null' for emtpy values. This works for pgsql.

But this changes the phpType for dates from string to date for all DB-Types. I'm not sure about all implications.

[cebe]

But this changes the phpType for dates from string to date for all DB-Types. I'm not sure about all implications.

There is no phpType "date".

[SaschaKoth]

Yes, sure! See #1255