[HACKERS] problem with plpgsql

2005-06-29 Thread Pavel Stehule
Hello In my code I evaluate expr select array(select generate_series from generate_series(1,800) my code var = (PLpgSQL_var *) (estate-datums[stmt-varno]); value = exec_eval_expr(estate, stmt-expr, isnull, valtype); exec_eval_cleanup(estate); and iteration over array

Re: [HACKERS] problem with plpgsql

2005-06-29 Thread Tom Lane
Pavel Stehule [EMAIL PROTECTED] writes: Hello In my code I evaluate expr select array(select generate_series from generate_series(1,800) my code var = (PLpgSQL_var *) (estate-datums[stmt-varno]); value = exec_eval_expr(estate, stmt-expr, isnull, valtype);

[HACKERS] Problem with plpgsql functions and foreign key constraints.

2001-05-28 Thread Brian Hirt
I recently ran across this (i think) bug relating to constraints and functions written in plpgsql. It seems that I'm getting erroneous foreign key violations. I've included two scripts which create the simplest test case I can reproduce. One script has a foreign key defined and the other one