SELECT pgv_insert('vars3', 'r1', row(1, 'str1', 'str2'));

ERROR: new record structure have 3 attributes, but variable "r1" structure have 2.

SELECT pgv_insert('vars3', 'r1', row(1, 1));

ERROR: new record attribute type for attribute number 2 differs from variable "r1" structure. You may need explicit type casts.

ERROR: new record attribute type for attribute number 2 differs from variable "r1" structure.

HINT: You may need explicit type casts.

SELECT pgv_insert('vars3', 'r1', row('str1', 'str1'));

ERROR: new record attribute type for attribute number 1 differs from variable "r1" structure. You may need explicit type casts.

ERROR: new record attribute type for attribute number 1 differs from variable "r1" structure.

HINT: You may need explicit type casts.

SELECT pgv_select('vars3', 'r1', ARRAY[[1,2]]); -- fail

ERROR: searching for elements in multidimensional arrays is not supported

-- Test variables caching

(1 row)

SELECT pgv_insert('vars', 'r2', foo) FROM foo;

ERROR: new record attribute type for attribute number 2 differs from variable "r2" structure. You may need explicit type casts.

ERROR: new record attribute type for attribute number 2 differs from variable "r2" structure.

HINT: You may need explicit type casts.

SELECT pgv_select('vars', 'r2');

pgv_select

------------

ereport(ERROR,

(errcode(ERRCODE_INVALID_PARAMETER_VALUE),

errmsg("new record attribute type for attribute number %d "

"need explicit type casts.",

i+1,GetName(variable))));

i+1,GetName(variable)),

errhint("You may need explicit type casts.")));

}

}