Re: [ADMIN] ERROR: column "time" cannot be cast to type bigint

2011-04-20 Thread Thomas Kellerer
Saurabh Agrawal, 20.04.2011 08:38: Hi All, I am trying to alter column from "timestamp without timezone" to "bigint" but getting below error: #ALTER TABLE test ALTER column time type bigint; #ERROR: column "time" cannot be cast to type bigint Is there any other method for alter column to bigi

[ADMIN] ERROR: column "time" cannot be cast to type bigint

2011-04-20 Thread Saurabh Agrawal
Hi All, I am trying to alter column from "timestamp without timezone" to "bigint" but getting below error: #ALTER TABLE test ALTER column time type bigint; #ERROR: column "time" cannot be cast to type bigint Is there any other method for alter column to bigint. Regards Saurabh Agrawal -- Sen