Postgres Pro
Downloads
Home   >   mailing lists

ERROR: column "time" cannot be cast to type bigint - Mailing list pgsql-admin

From Saurabh Agrawal
Subject ERROR: column "time" cannot be cast to type bigint
Date
Msg-id BANLkTi=g3mqZ2WLt6AHFjDzGFUyHfSP1gg@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: column "time" cannot be cast to type bigint
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Re: Reseting statistics, cluster wide
Next
From: Mlondolozi Ncapayi
Date:
Subject: How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7