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