prepared statements and DBD::Pg

[JP Fletcher <jpfletch@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general