prepared statements and DBD::Pg - Mailing list pgsql-general

Hi,

I see different behavior with DBI/DBD::Pg (1.607/2.11.8, pg 8.1) when
the first command in a prepared statement is 'CREATE TEMP TABLE'.

For instance, this works:

    my $prepare_sql =<<SQL;
        CREATE TEMP TABLE foo( id int, user_id int,);

        INSERT INTO foo(1, 1);

        INSERT INTO foo(2, 2);
            SQL

    my $sth = $dbh->prepare($prepare_sql);


This produces the error

ERROR:  cannot insert multiple commands into a prepared statement

my $prepare_sql =<<SQL;

        INSERT INTO foo(1, 1);

        INSERT INTO foo(2, 2);
            SQL

    my $sth = $dbh->prepare($prepare_sql);


Is this the expected behaviour?


--
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
jpfletch@ca.afilias.info