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 errorinsert into tickets select * from tickets_archive; column "ticket_purchase_no" is of type bigint but expression is of type character varyingRegardsA.Rama Krishnan
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных