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!