Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 18133
Status: resolved
Priority: 0/
Queue: DBD-Pg
People
Owner: Nobody in particular
Requestors: hertzog [...] debian.org
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Sun Mar 12 14:39:33 2006 Guest - Ticket created
Subject: Doesn't handle some explicit conversion anymore
This snipped of code used to work but doesn't since several versions : use DBI; my $dbh = DBI->connect( 'DBI:Pg:host=localhost', undef,undef, { RaiseError => 1 }); my $sth = $dbh->prepare('select interval ?'); $sth->execute( '1 hour' ); You get the following error : DBD::Pg::st execute failed: ERROR: syntax error at or near "$1" at character 17 This bug has been reported initially in the Debian Bug Tracking System: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=321917 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=315708
  Tue Jan 08 17:00:34 2008 greg [...] turnstep.com - Correspondence added
This is due to the fact that instead of emulating placeholders, DBD::Pg now uses the internal Postgres prepared statements. This means that only statements that are valid to Postgres can be used: your example was not one of them. To get the old behavior, you can set $dbh->{pg_server_prepare} = 0;
  Tue Jan 08 17:00:36 2008 The RT System itself - Status changed from 'new' to 'open'
  Tue Jan 08 17:00:37 2008 greg [...] turnstep.com - Status changed from 'open' to 'resolved'
  Wed Aug 27 20:42:05 2008 greg [...] turnstep.com - Broken in 1.42 deleted
  Wed Aug 27 20:42:05 2008 greg [...] turnstep.com - Broken in 1.42_1 deleted
  Wed Aug 27 20:42:05 2008 greg [...] turnstep.com - Broken in 1.43 deleted
  Wed Aug 27 20:42:05 2008 greg [...] turnstep.com - Broken in 1.43_1 deleted
  Wed Aug 27 20:42:06 2008 greg [...] turnstep.com - Broken in 1.43_2 deleted
  Wed Aug 27 20:42:06 2008 greg [...] turnstep.com - Broken in 1.44 deleted
  Wed Aug 27 20:42:06 2008 greg [...] turnstep.com - Broken in 1.45 deleted