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
This sequence seems impossible if executed all from the same psql session. So I presume you most likely aren't actually doing that, and so the psql output you show is meaningless since it doesn't show what the insert/select command is actually working with.
If you are, showing the results of "select * from {tickets|tickets_archive} limit 1" would be informative. Listing columns explicitly in the insert command and then putting an explicit cast on tickets_archive.ticket_purchase_no would also be interesting.