Re: pg_connect fails, pgsql works

From: John Cartwright <John(dot)C(dot)Cartwright(at)noaa(dot)gov>
To: rod(at)iol(dot)ie
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: pg_connect fails, pgsql works
Date: 2008-03-10 20:06:07
Message-ID: 47D594AF.8090105@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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(at)iol(dot)ie
> ---------------------------------------------------------------

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Raymond O'Donnell 2008-03-10 20:10:28 Re: pg_connect fails, pgsql works
Previous Message Raymond O'Donnell 2008-03-10 18:44:17 Re: pg_connect fails, pgsql works