On Tue, Jan 31, 2006 at 03:41:06PM +0100, Csaba Nagy wrote: > Is there any chance for psql opening a new session if it's inside a > transaction and use that to do whatever querying is needed ? Just > something like the control connection on ftp (analogy not very good). > That could cause other surprises though (could fail for example due to > too many connections open), and I have no idea about psql internals so > it might be completely against it's philosophy...
Well, one problem there is that the connection could well have different parameters, like search_path. Granted, probably wouldn't matter in this case, but... Plus of course there's the cost of startup. Something that's asked for periodically is the ability to run things outside of a current transaction. The normal reply is to use DBLink, but if there was backend support for that it could probably be used here. But I suspect adding that ability would be a pretty large amount of work :( -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
