prob with PERL/Postgres

From: "Kristopher Yates" <kris(at)grinz(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: prob with PERL/Postgres
Date: 2001-08-06 19:05:56
Message-ID: 3B6EA444.13097.C20296@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

PERL SNIPPET:

# build arrays from file (OMITTED)

use Pg;
$dbhost='127.0.0.1';
$dbname='mpact';
#$connstr="dbname=$dbname";
$connstr="host=$dbhost dbname=$dbname";
$conn = Pg::connectdb($connstr);

#more code related to date omitted

$result=$conn->exec($sql);
(PGRES_COMMAND_OK eq $result->resultStatus)
or die $conn->errorMessage;

WHY DO I GET PQsendQuery() -- There is no connection to the
backend. I have tried leaving host blank, using IP 127.0.0.1 and
hostname localhost. This script should work - the problem is
something with postgres but I dont know what. Any ideas out
there? Thanks, Kris

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Allan Engelhardt 2001-08-06 19:57:55 Re: Mirroring the database?
Previous Message Raymond Chui 2001-08-06 17:35:01 Mirroring the database?