in 4.50.33 'SSL Mode' does not exist and empty TEXT...
Posted: Tue 04 Aug 2009 12:06
FIRST :
in 4.50.33, connection string SSL Mode is no more supported (why ?)
SECONDLY :
Selecting a TEXT which actually is a ''::text becomes a DBNull
Example:
Select company from doms where uid=237
in that row, company is not null and equals ''.
In my dataset 'company' does not allow DBNull (for safety).
In the table the default value for 'company' is ''::text.
I double check in the database : company equals ''. This is correct.
Everything used to work but since 4.50.33, company is 'transformed' into DBNull.
Any idea ?
in 4.50.33, connection string SSL Mode is no more supported (why ?)
SECONDLY :
Selecting a TEXT which actually is a ''::text becomes a DBNull
Example:
Select company from doms where uid=237
in that row, company is not null and equals ''.
In my dataset 'company' does not allow DBNull (for safety).
In the table the default value for 'company' is ''::text.
I double check in the database : company equals ''. This is correct.
Everything used to work but since 4.50.33, company is 'transformed' into DBNull.
Any idea ?