prepared statements and DBD::Pg

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(at)ca(dot)afilias(dot)info