Re: plpgsql - wrong using of PERFORM statement doesn't raise a error

2016-12-23 10:14 GMT+01:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

> Hi
>
> Following command finishing without any error, but (as expected) do nothing
>
> postgres=# create table foo(a int);
> CREATE TABLE
> Time: 51,363 ms
> postgres=# DO $$
> postgres$# DECLARE t text;
> postgres$# BEGIN
> postgres$# t := 'INSERT INTO foo VALUES(10)';
> postgres$# PERFORM t;
> postgres$# END;
> postgres$# $$;
> DO
> Time: 4,375 ms
> postgres=# select * from foo;
> ┌───┐
> │ a │
> ╞═══╡
> └───┘
> (0 rows)
>
> Time: 1,367 ms
>
> Related to http://stackoverflow.com/questions/41294888/plpgsql-
> error-query-has-no-destination-for-result-data-on-a-parameter-declarati
>
> Regards
>

It generate valid command

SELECT t --> SELECT 'INSERT ...';

Hard to detect this issue.

Pavel

>
> Pavel Stehule
>