pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> ---------------------------------------------------------------



view thread (7+ messages)  latest in thread

Message-ID: <47D594AF.8090105@noaa.gov>
Permalink:  ../47D594AF.8090105@noaa.gov/
Also on:    postgresql.org/message-id/47D594AF.8090105@noaa.gov

 · 

reply

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