Re: Errors/Warnings missing line numbers

Greg,

I'm sorry for taking a month to reply to this...

I installed DBD::Pg 1.49 but I am still not seeing line numbers  
reported with errors or warnings from DBD::Pg... Is it really DBD::Pg  
or do I need a later version of something else?

(My version of perl, DBI, DBD::Pg)
$ perl -MDBI -e 'DBI->installed_versions'
   Perl            : 5.008006    (darwin-2level)
   OS              : darwin      (7.8.0)
   DBI             : 1.50
   DBD::Pg         : 1.49
   DBD::ExampleP   : 11.12

(My test program)
$ cat test.pl
#!/usr/bin/perl
use DBI;
$d = DBI->connect('DBI:Pg:dbname=template1','postgres','');
$q = $d->selectall_arrayref('select foo from bar');

(The results)
$ perl test.pl
DBD::Pg::db selectall_arrayref failed: ERROR:  relation "bar" does  
not exist


I'll be happy to test any patch you might come up with.

Thanks,
--Joel

Joel Richard
The Richard Group
joel-D6Ir9RiDehtbaj9gzE0k7wC/[email protected]
703-584-5802



On May 1, 2006, at 12:56 PM, Greg Sabino Mullane wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>> I was wondering if anyone else is experiencing this error. I reported
>> it to the maintainers of DBD::Pg last week through CPAN but have
>> heard no response.
>
> Where exactly did you send it? CPAN has some mailing issues,  
> especially when
> using their bug tracker.
>
>> Basically since upgrading to DBD::Pg 1.41 or later (I'm now on 1.48),
>> I don't get line numbers when there's an error in my SQL statement.
>
> Verified and fixed. This is probably related to the fact that the
> server can now return multi-line error messages (e.g. the HINT  
> directive),
> and we never tweaked things to leave all newlines except the last one.
>
> Thanks for the report: this will be part of 1.49, which will be  
> released
> sometime this week.
>
> - --
> Greg Sabino Mullane greg-738XdyZ4GzZWk0Htik3J/[email protected]
> PGP Key: 0x14964AC8 200605011149
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFEVi5/vJuQZxSWSsgRAsNcAJ0dllB6xDVN4oeI7H+DfeJ3FN2PvwCfYPR5
> AJPExFMDIUI3I22YE0T02og=
> =MuGj
> -----END PGP SIGNATURE-----
>
>
> _______________________________________________
> Dbdpg-general mailing list
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/dbdpg-general