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
Re: Sub:column "" is of type bigint but expression is of type character varying Re: Sub:column "" is of type bigint but expression is of type character varying |
| Список | pgsql-general |
Hi All,
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
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 |
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
Regards
A.Rama Krishnan
В списке pgsql-general по дате отправления: