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

[Rama Krishnan]

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