Bug #125404 for DBD-Pg: Update statements with rules

Sat May 26 09:55:59 2018 maros [...] k-1.com - Ticket created

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 https://0bin.net/paste/Y1tUMJycJCXt777W#rpOv7GG2iz448pyEiGjzjmL8lxQrXf6Mg7rKlfmLCHb 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š

Sat May 26 13:58:55 2018 MAROS [...] cpan.org - Correspondence added

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

Sat May 26 13:58:56 2018 The RT System itself - Status changed from 'new' to 'open'

Mon Jan 20 09:34:31 2020 greg [...] turnstep.com - Taken