Re: Change column type

On Mon, 17 Mar 2003, Oleg Lebedev wrote:

> I want to change a column type from VARCHAR to BIGINT. All values
> currently stored in the column are integers. Saving column data,
> recreating the column and restoring data seems to be too convoluted.
> Besides, I have multiple constraints declared on this column, which I
> will have to recreate once the column is dropped. I wonder if the
> easiest way to do this would be just to change the atttypid in
> pg_attribute?

I doubt it.  bigint and varchar() don't get stored the same, so I think
that'd only corrupt your table.

> I also wonder why it is possible to declare an FK constraint on a column
> of type VARCHAR to reference a PK column of type BIGINT?

The types are considered comparable since you can do an equality
comparison on them.