BD::Pg::db do failed: ERROR:

--e89a8f8394338546da052d1d005e
Content-Type: text/plain; charset=UTF-8

I'm using PostgreSQL 9.2.15-1PGDG.rhel6 on a Centos 6.7 64 Bits.

Hi all,

Got an issue using pg_sample:

When executing the command:

> ./pg_sample dbname --data-only --file=test.sql --limit="ja_admins = 1000"

I got the following error:

> Creating table "
>
> *pg_sample"."pg_catalog_pg_statistic" DBD::Pg::db do failed: ERROR: column
> "stavalues1" has pseudo-type "anyarray" at ./pg_sample line
> 296main::__ANON_**main::__ANON_*('DBD::Pg::db do failed: ERROR: column
> "stavalues1" has pseudo...', 'DBI::db=HASH(0xfdec08)', undef) called at
> ./pg_sample line 538
> Dropping sample schema _pg_sample
> Done.


Perl-DBD-pg-2.19.3 - Installed manually by:


   1. perl Makefile.PL
      2. make
      3. make test
      4. make install

Source: https://github.com/bucardo/dbdpg


What can I do to solve this issue?

Thanks!

--e89a8f8394338546da052d1d005e
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p style=3D"margin-bottom:16px;color:rgb(51,51,51);font-fa=
mily:&#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,s=
ans-serif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe U=
I Symbol&#39;;font-size:14px;line-height:22.4px;margin-top:0px!important">I=
&#39;m using PostgreSQL 9.2.15-1PGDG.rhel6 on a Centos 6.7 64 Bits.</p><p s=
tyle=3D"margin-top:0px;margin-bottom:16px;color:rgb(51,51,51);font-family:&=
#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,sans-se=
rif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symb=
ol&#39;;font-size:14px;line-height:22.4px">Hi all,</p><p style=3D"margin-to=
p:0px;margin-bottom:16px;color:rgb(51,51,51);font-family:&#39;Helvetica Neu=
e&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,sans-serif,&#39;Apple Co=
lor Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symbol&#39;;font-size=
:14px;line-height:22.4px">Got an issue using pg_sample:</p><p style=3D"marg=
in-top:0px;margin-bottom:16px;color:rgb(51,51,51);font-family:&#39;Helvetic=
a Neue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,sans-serif,&#39;App=
le Color Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symbol&#39;;font=
-size:14px;line-height:22.4px">When executing the command:<br></p><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-widt=
h:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-le=
ft:1ex">./pg_sample dbname --data-only --file=3Dtest.sql --limit=3D&quot;ja=
_admins =3D 1000&quot;</blockquote><p></p><p style=3D"margin-top:0px;margin=
-bottom:16px;color:rgb(51,51,51);font-family:&#39;Helvetica Neue&#39;,Helve=
tica,&#39;Segoe UI&#39;,Arial,freesans,sans-serif,&#39;Apple Color Emoji&#3=
9;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symbol&#39;;font-size:14px;line-h=
eight:22.4px">I got the following error:<br></p><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-=
color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Creating t=
able &quot;<em>pg_sample&quot;.&quot;pg_catalog_pg_statistic&quot; DBD::Pg:=
:db do failed: ERROR: column &quot;stavalues1&quot; has pseudo-type &quot;a=
nyarray&quot; at ./pg_sample line 296<br>main::__ANON_<br></em><em>main::__=
ANON_</em>(&#39;DBD::Pg::db do failed: ERROR: column &quot;stavalues1&quot;=
 has pseudo...&#39;, &#39;DBI::db=3DHASH(0xfdec08)&#39;, undef) called at .=
/pg_sample line 538<br>Dropping sample schema _pg_sample<br>Done.</blockquo=
te><p></p><p style=3D"margin-top:0px;color:rgb(51,51,51);font-family:&#39;H=
elvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,sans-serif,&=
#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symbol&#3=
9;;font-size:14px;line-height:22.4px;margin-bottom:0px!important"><br></p><=
p style=3D"margin-top:0px;color:rgb(51,51,51);font-family:&#39;Helvetica Ne=
ue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesans,sans-serif,&#39;Apple C=
olor Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Segoe UI Symbol&#39;;font-siz=
e:14px;line-height:22.4px;margin-bottom:0px!important">Perl-DBD-pg-2.19.3 -=
 Installed manually by:</p><pre style=3D"overflow:auto;font-family:Consolas=
,&#39;Liberation Mono&#39;,Menlo,Courier,monospace;font-size:15px;margin-to=
p:0px;margin-bottom:0px;font-stretch:normal;white-space:pre-wrap;color:rgb(=
51,51,51)"><ol><ol><li>perl Makefile.PL</li><li>make</li><li>make test</li>=
<li>make install</li></ol></ol></pre><p style=3D"margin-top:0px;color:rgb(5=
1,51,51);font-family:&#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,=
Arial,freesans,sans-serif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#=
39;,&#39;Segoe UI Symbol&#39;;font-size:14px;line-height:22.4px;margin-bott=
om:0px!important">Source: <a href=3D"https://github.com/bucardo/dbdpg">http=
s://github.com/bucardo/dbdpg</a></p><p style=3D"margin-top:0px;color:rgb(51=
,51,51);font-family:&#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,A=
rial,freesans,sans-serif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#3=
9;,&#39;Segoe UI Symbol&#39;;font-size:14px;line-height:22.4px;margin-botto=
m:0px!important"><br></p><p style=3D"margin-top:0px;color:rgb(51,51,51);fon=
t-family:&#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe UI&#39;,Arial,freesa=
ns,sans-serif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI Emoji&#39;,&#39;Seg=
oe UI Symbol&#39;;font-size:14px;line-height:22.4px;margin-bottom:0px!impor=
tant">What can I do to solve this issue?</p><p style=3D"margin-top:0px;colo=
r:rgb(51,51,51);font-family:&#39;Helvetica Neue&#39;,Helvetica,&#39;Segoe U=
I&#39;,Arial,freesans,sans-serif,&#39;Apple Color Emoji&#39;,&#39;Segoe UI =
Emoji&#39;,&#39;Segoe UI Symbol&#39;;font-size:14px;line-height:22.4px;marg=
in-bottom:0px!important">Thanks!</p></div>

--e89a8f8394338546da052d1d005e--