insert into T_pkey1 values (1, 'key1-1', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey1 values (1, 'key1-2', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey1 values (1, 'key1-3', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey1 values (2, 'key2-1', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey1 values (2, 'key2-2', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey1 values (2, 'key2-3', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (1, 'key1-1', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (1, 'key1-2', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (1, 'key1-3', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (2, 'key2-1', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (2, 'key2-2', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (2, 'key2-3', 'test key'); ERROR: pltcl: internal error - cannot create 'normal' interpreter select * from T_pkey1; key1 | key2 | txt ------+------+----- (0 rows) select * from T_pkey2; key1 | key2 | txt ------+------+----- (0 rows) insert into T_pkey1 values (1, 'KEY1-3', 'should work'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta1 values ('trec 1', 1, 'key1-1'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta1 values ('trec 2', 1, 'key1-2'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta1 values ('trec 3', 1, 'key1-3'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta1 values ('trec 4', 1, 'key1-4'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta2 values ('trec 1', 1, 'KEY1-1'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta2 values ('trec 2', 1, 'KEY1-2'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta2 values ('trec 3', 1, 'KEY1-3'); ERROR: pltcl: internal error - cannot create 'normal' interpreter insert into T_dta2 values ('trec 4', 1, 'KEY1-4'); ERROR: pltcl: internal error - cannot create 'normal' interpreter select * from T_dta1; tkey | ref1 | ref2 ------+------+------ (0 rows) select * from T_dta2; tkey | ref1 | ref2 ------+------+------ (0 rows) update T_pkey1 set key2 = 'key2-9' where key1 = 2 and key2 = 'key2-1'; update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; delete from T_pkey1 where key1 = 2 and key2 = 'key2-2'; delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; update T_pkey2 set key2 = 'KEY2-9' where key1 = 2 and key2 = 'KEY2-1'; update T_pkey2 set key2 = 'KEY1-9' where key1 = 1 and key2 = 'KEY1-1'; delete from T_pkey2 where key1 = 2 and key2 = 'KEY2-2'; delete from T_pkey2 where key1 = 1 and key2 = 'KEY1-2'; select * from T_pkey1; key1 | key2 | txt ------+------+----- (0 rows) select * from T_pkey2; key1 | key2 | txt ------+------+----- (0 rows) select * from T_dta1; tkey | ref1 | ref2 ------+------+------ (0 rows) select * from T_dta2; tkey | ref1 | ref2 ------+------+------ (0 rows) select tcl_avg(key1) from T_pkey1; ERROR: pltcl: internal error - cannot create 'normal' interpreter select tcl_sum(key1) from T_pkey1; tcl_sum --------- 0 (1 row) select tcl_avg(key1) from T_pkey2; ERROR: pltcl: internal error - cannot create 'normal' interpreter select tcl_sum(key1) from T_pkey2; tcl_sum --------- 0 (1 row) select tcl_avg(key1) from T_pkey1 where key1 = 99; ERROR: pltcl: internal error - cannot create 'normal' interpreter select tcl_sum(key1) from T_pkey1 where key1 = 99; tcl_sum --------- 0 (1 row) select 1 @< 2; ERROR: pltcl: internal error - cannot create 'normal' interpreter select 100 @< 4; ERROR: pltcl: internal error - cannot create 'normal' interpreter select * from T_pkey1 order by key1 using @<, key2; key1 | key2 | txt ------+------+----- (0 rows) select * from T_pkey2 order by key1 using @<, key2; key1 | key2 | txt ------+------+----- (0 rows)