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

�ς�� 2013/03/17

• Windows TIPS�F.bat�t�@�C���̊֘A�t�������ɖ߂� - @IT (2013/03/15)
• �}���`�v���C���[�ɂ��Ή�����HTML5�ɂ��u���[�^���R���o�b�g�v - IDEA*IDEA (2013/03/05)
• �uFirefox OS�v�G���Ă݂��B�Ƃ������N�ł�PC�ŋN���ł��܂� �y���c @maskin�z - TechWave (2013/02/25)
• �yiOS�z�ӊO�ƒm���ĂȂ��HApple�����̂�������T���v���R�[�h��10�‚قǂ܂Ƃ� - @kitano_ow 's blog (2013/02/27)