Received: from mars.netsecure.net (mars.netsecure.net [208.246.240.244]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76J9u697115 for ; Mon, 6 Aug 2001 15:09:57 -0400 (EDT) (envelope-from kris@grinz.com) Received: from shadow (net-216-37-70-199.in-addr.worldspice.net [216.37.70.199]) by mars.netsecure.net (Postfix) with ESMTP id F1E1ADB11 for ; Mon, 6 Aug 2001 15:09:55 -0400 (EDT) From: "Kristopher Yates" To: pgsql-sql@postgresql.org Date: Mon, 6 Aug 2001 14:05:56 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: prob with PERL/Postgres Reply-To: kris@grinz.com Message-ID: <3B6EA444.13097.C20296@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200108/61 X-Sequence-Number: 4282 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