From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | Michael Meskes <meskes(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Connection string |
Date: | 2006-08-11 16:09:16 |
Message-ID: | 20060811160916.GA4924@1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Aug 11, 2006 at 07:01:55AM -0600, Michael Fuhr wrote:
> The ECPG "Connecting to the Database Server" documentation does
> have an example for Unix sockets with quotes:
>
> EXEC SQL CONNECT TO 'unix:postgresql://sql.mydomain.com/mydb' AS myconnection USER john;
>
> Should that be changed? It's wrong on two counts as far as
I think so yes.
> I'm thinking that example should be:
>
> EXEC SQL CONNECT TO unix:postgresql://localhost/mydb AS myconnection USER john;
Right.
> In practice, it is probably less error-prone to use a (single-quoted)
> string literal or a variable reference.
>
> which might be the source of confusion here.
This should be fixed. You're absolutely right.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Francis GUDIN | 2006-08-11 16:10:48 | Re: VACUUM VERBOSE output to STDERR |
Previous Message | Jasbinder Bali | 2006-08-11 16:04:46 | Re: Unable to connect to PostgreSQL 8 from PGAdmin III |