John D. Burger wrote:
The only annoyance is that the interface I use most often, Python's
pgdb, runs everything in a transaction, and you can't analyze in a
transaction.
Hm? We've allowed ANALYZE inside a transaction for a long time.
I'm stuck with using 7.2, for now, and I get this:
ERROR: ANALYZE cannot run inside a BEGIN/END block
I'll be happy to find out that this restriction's been removed in later
versions.
Your running 7.2? That is all kinds of level of... huh? Why?
Sincerely,
Joshua D. Drake
- John D. Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
