이유를 모르겠습니다.

subul=# \d prod

Table "public.prod"

Column | Type | Modifiers

------------+--------------+------------------------

prod_id | character(7) | not null

prod | text | not null

remark | text |

prodcat_id | character(1) | not null

pb | boolean | not null default false

Indexes:

"prod_pkey" PRIMARY KEY, btree (prod_id)

"prod_prod_key" UNIQUE, btree (prod)

Foreign-key constraints:

"prodcat_fkey" FOREIGN KEY (prodcat_id) REFERENCES prodcat(prodcat_id) ON UPDATE CASCADE

subul=# UPDATE prod SET prod_id = 'AAAAAAB', prod = 'test', prodcat_id = 'C', pb = 'f', remark = '' WHERE prod_id = 'AAAAAAA';

ERROR: column "prod_id" is of type integer but expression is of type character

HINT: You will need to rewrite or cast the expression.

CONTEXT: SQL statement "UPDATE ONLY "public"."prodstock" SET "prod_id" = $1 WHERE "prod_id" = $2"