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

Поиск
Список
Период
Сортировка
От Rama Krishnan
Тема Sub:column "" is of type bigint but expression is of type character varying
Дата
Msg-id CAJWX+ENJ-Z6Unwru0PR+WBvi4eJjYJay9GPyeCNvXxSBe5Rkmw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Sub:column "" is of type bigint but expression is of type character varying  (JITEN KUMAR SHAH <jitenshah78@gmail.com>)
Re: Sub:column "" is of type bigint but expression is of type character varying  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Sub:column "" is of type bigint but expression is of type character varying  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Would it be possible to add functions to tab-completion in psql?
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Can I get the number of results plus the results with a single query?