Re: ODBC & v7.0(Rel) Errors with Users and Databases

Dave Page writes:

> ERROR: DROP DATABASE: May not be called in a transaction block

This command can't be rolled back so you aren't allowed to try. This was
thought as an improvement. In general, a database isn't a database object
so one shouldn't be transacting around with them. (Same goes for users.)

> The ODBC log (and knowledge that it isn't pgAdmin or M$ ADO) shows that the
> ODBC driver is automatically wrapping the query in a transaction.

I don't know anything about ODBC but it certainly should provide a means
to execute a command without that wrapping block. Is this a special
function or do you just execute some exec("DROP DATABASE") style call?

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden