Studio ODIN

cross-database references are not implemented

PostgreSQL �� PL/pgSQL �̃g���K�[�� �ȉ��̂悤�ȃG���[���ł邱�Ƃ�����܂��B

ERROR:  cross-database references are not implemented: test.table1.column1
CONTEXT:  compilation of PL/pgSQL function "test_af_chg" near line 4

�����̂ЂƂ‚Ƃ��āAPL/pgSQL �v���O�������� �ϐ��̒�`�� %TYPE �������Ă�ꍇ������܂��B

DECLARE
   wk_column1 test.table1.column1;

���̏ꍇ�A��L�̃G���[���ł܂��B

�������́A���̂悤�ɂȂ�܂��B

DECLARE
   wk_column1 test.table1.column1%TYPE;

�ӊO�ƋC�Â��ɂ����ł��B