punkish has asked for the wisdom of the Perl Monks concerning the following question: 

#!perl

use strict;
use DBI;
my $dbh = DBI->connect(
  "dbi:Pg:dbname=postgres", 
  "punkish", 
  "punkish", 
  {AutoCommit => 0}
);

[download]

Crash and burn... Windows dialog box -- Perl Command Line Interpreter has encountered a problem and needs to close.

Any ideas, anyone?

--

when small people start casting long shadows, it is time to go to bed

Replies are listed 'Best First'.
Re: DBD-Pg crashes on Win32
by davidrw (Prior) on Aug 19, 2006 at 18:44 UTC
    no other info from the windows message or from STDOUT/STDERR?

    is postgres otherwise completely functional? i.e. do pgAdmin, pg_dump, psql, etc do all work successfully with the same connection information?
[reply]
      > no other info from the windows message or > from STDOUT/STDERR?

      nope. Only the MS-Windows window with the following additional info 

      Error signature-------------
  AppName: perl.exe  AppVer: 5.8.8.817 ModName: unknown
  ModVer: 0.0.0.0    Offset: 00905a4d

blah blah

      [download]

      > is postgres otherwise completely functional?

      unfortunately, yes. So, no help there.

      > i.e. do pgAdmin, pg_dump, psql, etc do all work > successfully with the same connection information?

      Yes, pgAdmin and psql work (didn't try pg_dump)

      --

      when small people start casting long shadows, it is time to go to bed
[reply]
[d/l]
        Did you check in windows Event Viewer? How did you install DBI/DBD-Pg?
[reply]
Re: DBD-Pg crashes on Win32
by syphilis (Archbishop) on Aug 20, 2006 at 07:00 UTC
    Activestate perl, v5.8.8 built for MSWin32-x86-multi-thread

    That would be build 817 ? (Don't use build 816.):

    perl -e "print $ActivePerl::VERSION"

    Cheers,
    Rob
[reply]
      >perl -e "print $ActivePerl::VERSION"
817
>

      [download]

      I have build 817. Are you saying that should be good? Because, it is not, at least as far as DBD::Pg is concerned. Still crashes. As a result, I can't do anything with my PostGres install via Perl.

      --

      when small people start casting long shadows, it is time to go to bed
[reply]
[d/l]
        I have build 817. Are you saying that should be good?

        Yep ... at least it doesn't suffer from known (significant) problems that afflicted build 816.

        Perhaps someone at the dbdpg-general mailing list can provide advice. (See the README that comes with the DBD::Pg source for details - http://search.cpan.org/src/DBDPG/DBD-Pg-1.49/README .)

        Cheers,
        Rob
[reply]
Re: DBD-Pg crashes on Win32
by Anonymous Monk on May 30, 2007 at 14:16 UTC
    1.49 is the latest version of DBD::Pg, you might want to try that first as some important bugs have been fixed.
[reply]
Re: DBD-Pg crashes ?Resolved?
by Anonymous Monk on Sep 25, 2007 at 23:10 UTC
    Hi, I'm wondering if this issue was ever resolved. I am experiencing the same exact thing. Can you let me know how you fixed it, if indeed you did??? Many TIA, Case
[reply]
      Ditto Here.. Any solution?
[reply]

        FWIW: there are DBD::Pg windows ppms at pgFoundry (lots of other PostgreSQL goodies on pgFoundry, btw )

        Copy into a local directory and give that directory to ppm as a repository to install ( for instance file:///c:/downloads/DBD-Pg-binaries )

        It works for me; I use it regularly.

        Oh and btw - DBD::Pg 2.0 wil be coming out RSN ( developer version 2.0.0_5 is on CPAN now, which works fine too ).

[reply]

Back to Seekers of Perl Wisdom