Re: [GENERAL] prepared statements and DBD::Pg

2009-07-14 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 It's perfectly valid (from the DBI's point of view) for prepare() to return a prepared statement handle for an invalid statement.

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread Tim Bunce
On Thu, May 07, 2009 at 06:08:12PM -0700, David Fetter wrote: On Fri, May 08, 2009 at 01:02:04AM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote: On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 04:54:06AM +1200,

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread Daniel Verite
Tim Bunce wrote: So you're okay with breaking previously working, and prefectly valid, DBI code? I think the rationale is that such code was working by virtue of how prepare() was implemented in DBD::Pg, but was not valid nonetheless, as outlined with this example:

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread David Fetter
On Fri, May 08, 2009 at 09:44:56AM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 06:08:12PM -0700, David Fetter wrote: On Fri, May 08, 2009 at 01:02:04AM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote: On Thu, May 07, 2009 at 02:31:08PM +0100, Tim

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread Tim Bunce
On Fri, May 08, 2009 at 04:02:29PM +0200, Daniel Verite wrote: Tim Bunce wrote: So you're okay with breaking previously working, and prefectly valid, DBI code? I think the rationale is that such code was working by virtue of how prepare() was implemented in DBD::Pg, but was not

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread Daniel Verite
Tim Bunce wrote: The example that started this thread was that this valid statement worked: prepare(CREATE TEMP TABLE foo(...); INSERT INTO foo(1, 1); INSERT INTO foo(2, 2);) but this valid statement didn't: prepare( INSERT INTO foo(1, 1); INSERT INTO foo(2, 2);) My

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-08 Thread JP Fletcher
Daniel Verite wrote: Tim Bunce wrote: The example that started this thread was that this valid statement worked: prepare(CREATE TEMP TABLE foo(...); INSERT INTO foo(1, 1); INSERT INTO foo(2, 2);) but this valid statement didn't: prepare( INSERT INTO foo(1, 1);

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-07 Thread Tim Bunce
On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote: 2009/5/7 JP Fletcher jpfle...@ca.afilias.info: 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

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-07 Thread David Fetter
On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote: 2009/5/7 JP Fletcher jpfle...@ca.afilias.info: 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

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-07 Thread Tim Bunce
On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote: On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote: WARNING: DBD::Pg now (as of version 1.40) uses true prepared statements by sending them to the backend to be

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-07 Thread David Fetter
On Fri, May 08, 2009 at 01:02:04AM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 06:50:11AM -0700, David Fetter wrote: On Thu, May 07, 2009 at 02:31:08PM +0100, Tim Bunce wrote: On Thu, May 07, 2009 at 04:54:06AM +1200, Andrej wrote: WARNING: DBD::Pg now (as of version 1.40) uses

[GENERAL] prepared statements and DBD::Pg

2009-05-06 Thread JP Fletcher
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

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-06 Thread Keary Suska
On May 6, 2009, at 9:39 AM, JP Fletcher wrote: 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,);

Re: [GENERAL] prepared statements and DBD::Pg

2009-05-06 Thread Andrej
2009/5/7 JP Fletcher jpfle...@ca.afilias.info: 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,);