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

1. Please check you tickets_archive.ticket_purchase_no data type.

2. check if you are using correct schema.

On 8/17/22 14:23, Rama Krishnan wrote:
> 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