ERROR: column "time" cannot be cast to type bigint

From: Saurabh Agrawal <saurabh(dot)miet(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: column "time" cannot be cast to type bigint
Date: 2011-04-20 06:38:46
Message-ID: BANLkTi=g3mqZ2WLt6AHFjDzGFUyHfSP1gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mlondolozi Ncapayi 2011-04-20 07:02:31 How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7
Previous Message Selva manickaraja 2011-04-20 04:20:27 Re: Orphan Temp Table After PITR