What's the best way to create a connection with dblink with persisted
connections for web applications?
It all depends on how you intend to use the dblink connections.
If your web page connects to Postgres, issues a single query using dblink (via a view or whatever), and then completes, you don't need a persistent dblink connection -- just use the explicit connection syntax.
If, on the other hand, your web page connects to Postgres, issues several queries using dblink (via a view or whatever), and then completes, it would make sense to use a persistent dblink connection. In that case, execute dblink_connect() before you execute your queries. Use named persistent connections if you need more than one, anonymous otherwise.
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
