Re: Sub:column "" is of type bigint but expression is of type character varying - Mailing list pgsql-general

From JITEN KUMAR SHAH
Subject Re: Sub:column "" is of type bigint but expression is of type character varying
Date
Msg-id d6894447-5535-1f5a-0ad4-9153de0cea45@GMAIL.COM
Whole thread Raw
In response to Sub:column "" is of type bigint but expression is of type character varying  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Postgres question
Next
From: ajay venki
Date:
Subject: Re: Postgres question