this is unrelated to the URL scheme. i committed a one liner in 1539 that does not include the blank parameters in the keyword argument list if not found in the URL.

to see why PG was doing this, try this:

psycopg2.connect(database='blabla2', user='blalbla1', password='blabla', host='')


On May 28, 2006, at 2:59 PM, Valentino Volonghi aka Dialtone wrote:



On Sun, 28 May 2006 14:51:55 -0400, Michael Bayer <[EMAIL PROTECTED]> wrote:

On May 28, 2006, at 2:36 PM, Valentino Volonghi aka Dialtone wrote:
The new way of specifiying the dabatase parameters that uses an url is worse than the previous one IMHO since it doesn't allow me to avoid specifying an host and a port and I have to rely on passing my own QueuePool() which causes the other problems though.

Any solution?

how about:

postgres://username:password@/databasename

with the following string:
postgres://dialtone:pwd@/stiq

====================================================================== =========
[ERROR]: stiq.test.test_ui.TestCase.testMostBasic

File "/Volumes/dati/Sviluppo/stiq/stiq/test/utils.py", line 61, in setUp
   d = super(BaseUITest, self).setUp()
File "/Volumes/dati/Sviluppo/stiq/stiq/test/utils.py", line 24, in setUp
   database.dropDatabaseTable()
File "/Volumes/dati/Sviluppo/stiq/stiq/storage/postgres.py", line 137, in dropDatabaseTable
   if isinstance(e.orig, psycopg2.ProgrammingError):
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/schema.py", line 227, in drop
   self.engine.drop(self)
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 384, in drop self._run_visitor(self.dialect.schemadropper, entity, connection=connection, **kwargs) File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 401, in _run_visitor
   conn = self.contextual_connect()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 461, in contextual_connect return Connection(self, close_with_result=close_with_result, **kwargs) File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 177, in __init__
   self.__connection = connection or engine.raw_connection()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 479, in raw_connection
   return self.connection_provider.get_connection()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ default.py", line 34, in get_connection
   return self._pool.connect()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py", line 84, in connect
   return ConnectionFairy(self).checkout()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py", line 130, in __init__
   self.connection = pool.get()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py", line 102, in get
   return self.do_get()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py", line 229, in do_get
   return self._creator()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/ default.py", line 27, in <lambda> self._pool = poolclass(lambda: dbapi.connect(*cargs, **cparams), **kwargs) psycopg2.OperationalError: could not translate host name "user=dialtone" to address: No address associated with nodename


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel? cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to