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@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!