Re: Sub:column "" is of type bigint but expression is of type character varying

Hi All,

I am having table name called tickets

\d tickets

            Column            |            Type             | Collation | Nullable | Default

------------------------------+-----------------------------+-----------+----------+---------

 id                           | bigint                      |                        | not null |

 ticket_purchase_no| bigint                     |                        | not null | 

this below table contains more than 2 years old data

\d tickets_archive 

            Column            |            Type             | Collation | Nullable | Default

------------------------------+-----------------------------+-----------+----------+---------

 id                           | bigint                      |                        | not null |

 ticket_purchase_no| bigint                     |                        | not null | 

i have purged the old data from orginal table when i am restoring the data from archive table into orignal table i am getting the error

insert into tickets select * from tickets_archive;

 column "ticket_purchase_no" is of type bigint but expression is of type character varying
Regards

A.Rama Krishnan