changing the default value for a column

2007-06-16 Thread Amir Michail
Hi, The column in question has type timestamp yet this doesn't work: ij alter table tablename alter column columnname default current_timestamp; ERROR 22005: An attempt was made to get a data value of type 'long' from a data value of type 'TIMESTAMP'. The table does not have any rows. Amir

Re: changing the default value for a column

2007-06-16 Thread Bryan Pendleton
Amir Michail wrote: The column in question has type timestamp yet this doesn't work: ij alter table tablename alter column columnname default current_timestamp; ERROR 22005: An attempt was made to get a data value of type 'long' from a data value of type 'TIMESTAMP'. The table does not have