"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Would \c# limit us to 9 concurrent connections? Might want > > \cs[witch] [session]
Hm, we kind of have a choice with \c#. Either we treat it as part of the command in which case the way to connect to an integer-named database is to include a space. We could even have it magically connect to a database if the connection isn't already active. But these kinds of inconsistent behaviours can be traps for users. It means "\c1" and "\c 1" do different things even though "\cpostgres" and \c postgres" do the same thing. And it means "\c1" might connect to a database named "1" today but switch sessions tomorrow. Or we treat it as the first argument in which case even "\c 9" switches to session 9. I would prefer to do that but I fear there may be people with databases named "9". -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
