Package: postgresql-7.4 Version: 1:7.4.8-14 Severity: important Consider the following Perl code:
use DBI;
my $dbh = DBI->connect( 'DBI:Pg:host=localhost', undef,undef, { RaiseError => 1
});
my $sth = $dbh->prepare('select interval ?');
$sth->execute( '1 hour' );
This used to work with postgresql-7.4 1:7.4.8-9 and libdbd-pg-perl 1.42-1,
but with libdbd-pg-perl 1.42-2 and postgresql-7.4 1:7.4.8-14 I get the
following error message:
DBD::Pg::st execute failed: ERROR: syntax error at or near "$1" at character 17
I have searched through the documentation, but haven't found any better
means to convert a string to an interval. Or am I missing something? This
completely breaks my Perl script, thus I'm setting severity to "important".
Thanks,
- Stephan.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12-1-k7
Locale: LANG=en_GB.ISO-8859-15, LC_CTYPE=en_GB.ISO-8859-15 (charmap=ISO-8859-15)
Versions of packages postgresql-7.4 depends on:
ii libc6 2.3.5-3 GNU C Library: Shared libraries an
ii libcomerr2 1.38-1 common error description library
ii libkrb53 1.3.6-4 MIT Kerberos runtime libraries
ii libpam0g 0.76-23 Pluggable Authentication Modules l
ii libpq3 1:7.4.8-14 PostgreSQL C client library
ii libreadline5 5.0-10 GNU readline and history libraries
ii libssl0.9.7 0.9.7g-1 SSL shared libraries
ii postgresql-client-7.4 1:7.4.8-14 front-end programs for PostgreSQL
ii postgresql-common 23 manager for PostgreSQL database cl
ii zlib1g 1:1.2.3-3 compression library - runtime
postgresql-7.4 recommends no packages.
-- no debconf information
signature.asc
Description: Digital signature
