Thread: ECPG connect by URL doesn't work

According to this documentation

http://www.postgresql.org/docs/8.1/static/ecpg-connect.html

it should work to connect in ECPG like this:

EXEC SQL CONNECT TO tcp:postgresql://bell.credativ.de:5432/pei AS myconn USER pei IDENTIFIED BY 'geheim';

(Or perhaps with single quotes, but that doesn't make a difference.)

However, in the server logs I just see this:

FATAL:  database "'tcp:postgresql://bell.credativ.de:5432/pei'" does not exist

So apparently this URL parsing needs work.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Tue, Jan 31, 2006 at 12:31:24PM +0100, Peter Eisentraut wrote:
> According to this documentation
>
> http://www.postgresql.org/docs/8.1/static/ecpg-connect.html
>
> it should work to connect in ECPG like this:
>
> EXEC SQL CONNECT TO tcp:postgresql://bell.credativ.de:5432/pei AS myconn USER pei IDENTIFIED BY 'geheim';
>
> (Or perhaps with single quotes, but that doesn't make a difference.)

The example with the single quote is incorrect. I just changed the docs
accordingly.

Without the single quotes though, the statement should work.

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!