From: John Cartwright <John.C.Cartwright@noaa.gov>
To: rod@iol.ie
Cc: pgsql-php@postgresql.org
Subject: Re: pg_connect fails, pgsql works
Date: Mon, 10 Mar 2008 14:06:07 -0600
Message-ID: <47D594AF.8090105@noaa.gov> (raw)
In-Reply-To: <47D58181.2080205@iol.ie>
References: <47D571EF.8020408@noaa.gov>
<47D58181.2080205@iol.ie>
Thanks for your suggestion Ray, but I get the same error even w/o the
values being single-quoted.
-- john
Raymond O'Donnell wrote:
> On 10/03/2008 17:37, John Cartwright wrote:
>
>> $con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432
>> sslmode='allow' user='test' password='mypassword' dbname='test'")
>
> I don't think you need to quote the host, uid, etc - try it without
> the single quotes, e.g.
>
> "host=postgres1.ngdc.noaa.gov port=5432 sslmode=allow user=test [....]"
>
> HTH,
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> ---------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: John.C.Cartwright@noaa.gov, rod@iol.ie
Subject: Re: pg_connect fails, pgsql works
In-Reply-To: <47D594AF.8090105@noaa.gov>
References: <47D571EF.8020408@noaa.gov> <47D58181.2080205@iol.ie> <47D594AF.8090105@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox