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

Report information
The Basics
Id:
125404
Status:
open
Priority:
Low/Low
Queue:

People
Owner:
greg [...] turnstep.com
Requestors:
maros [...] k-1.com
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



Subject: Update statements with rules
Date: Sat, 26 May 2018 15:55:46 +0200
To: bug-DBD-Pg@rt.cpan.org
From: Maroš Kollár <maros@k-1.com>
I'm not sure if this is a genuine bug or if i'm using DBD::Pg in a wrong way, but I can't seem to be able to read records returned by an update statement altered by rules. The rule returns an additional row on a successful update. However using fetch on this statement handle throws an exception.

See the following test example

Issuing the same statements via psql works fine and returns both the affected row count as well as the extra rows added by the rule.

Cheers
Maroš
DBD::Pg 3.6.2. DBI 1.641. Postgres 9.6.7. Summary of my perl5 (revision 5 version 22 subversion 3) configuration: Platform: osname=linux, osvers=3.16.0-4-amd64, archname=x86_64-linux uname='linux buildslave 3.16.0-4-amd64 #1 smp debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 gnulinux ' config_args='-Dprefix=/opt/gh/perl-5.22.3-live -des -Dusedevel -Duseshrplib -Accflags=-DNO_TAINT_SUPPORT -Accflags=-mtune=core2 -Accflags=-fPIC -Accflags=-DPERL_DISABLE_PMC -Acc flags=-ggdb -Dman1dir=none -Dman3dir=none -A'eval:scriptdir=/opt/gh/perl-5.22.3-live/bin'' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.