42P01: relation does not exist when using temp table

[vadimi]

Hi,
The following code throws 42P01: relation "r1" does not exist exception:

using (var conn = new Npgsql.NpgsqlConnection("Server=localhost;Database=db1;Username=user;Password=password;"))
{
    var q = @"
        create temp table r1(datasource_id integer);
        select * from r1;";

    conn.Open();

    using (var cmd = new NpgsqlCommand())
    {
        cmd.Connection = conn;
        cmd.CommandText = q;
        using (var reader = cmd.ExecuteReader())
        {
        }
    }
}

It was working fine with 2.2.5

[kae]

@vadimi http://www.npgsql.org/doc/migration-3.0.html

It is no longer possible to create database entities (tables, functions) and then use them in the same multi-query command - you must first send a command creating the entity, and only then send commands using it. See #641 for more details.

[vadimi]

@kae thank you! Closing this one as duplicate.