16 Jan
2018
16 Jan
'18
3:02 p.m.
Anybody, an idea ?
On Tue, Jan 9, 2018 at 1:13 PM, Ariel Abadi
Hi! It seems to be, that there is a BUG on the statement CREATE TABLE..
It is not being consider the *DEFAULT property.*
Take a look on the following example:
sql>CREATE TABLE test (updated TIMESTAMP(0) DEFAULT current_timestamp()); operation successful (1.433ms) sql>\d test CREATE TABLE "sb_traf"."test" ( "updated" TIMESTAMP(0) DEFAULT current_timestamp() );
sql>CREATE TABLE test2 (LIKE test); operation successful (1.102ms) sql>\d test2 CREATE TABLE "sb_traf"."test2" ( "updated" TIMESTAMP(0) );
May be Im missing something, if thats the case, please let me know! Rgds Ariel