The ODBC driver has trouble with 7.0.x for some apps. 7.0.x has some
additional "error checking" which rejects some commands appearing inside
of transactions. Can we consider relaxing this, particularly since we
are considering making some of these "rejecting conditions"
transaction-friendly in a future release? Dumping work into ODBC and
other drivers to work around this is a diversion from other projects,
and I'm not sure we'll have much to show for it in the end.

btw, this is a continuation of the discussion regarding protecting users
from themselves vs handing them an ever-sharper tool. Usually I'll vote
for working on sharpening the tool rather than dulling it to protect a
naive user. I'll avoid using the analogy to the evolution of barbecue
lighter fluid, which in recent years is no longer very risky, but also
has trouble lighting barbecues :/

                - Thomas

Fri, 16 Jun 2000 16:26:24 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
create user and transactions
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> The ODBC driver has trouble with 7.0.x for some apps. 7.0.x has some
> additional "error checking" which rejects some commands appearing inside
> of transactions. Can we consider relaxing this, particularly since we
> are considering making some of these "rejecting conditions"
> transaction-friendly in a future release?

I thought all along that having CREATE USER et al refuse to run
inside a transaction was a bad idea.  Peter?

			regards, tom lane

Fri, 16 Jun 2000 12:51:57 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: create user and transactions 
Thomas Lockhart writes:

> The ODBC driver has trouble with 7.0.x for some apps. 7.0.x has some
> additional "error checking" which rejects some commands appearing inside
> of transactions. Can we consider relaxing this, particularly since we
> are considering making some of these "rejecting conditions"
> transaction-friendly in a future release?

I can supply a patch for the create/drop user case since there's not much
to be lost there. But what about databases? AFAIK there are no plans on
making their creation and removal transaction friendly at all, so we'd be
in "NOTICE: don't do that" mode for a very long time.


-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Sat, 17 Jun 2000 15:02:11 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: create user and transactions
Peter Eisentraut <peter_e@gmx.net> writes:
> I can supply a patch for the create/drop user case since there's not much
> to be lost there. But what about databases? AFAIK there are no plans on
> making their creation and removal transaction friendly at all, so we'd be
> in "NOTICE: don't do that" mode for a very long time.

Agreed, we have no plans to support rollbackable CREATE or DROP
DATABASE, so I don't have an objection to erroring out on them.

But the user & group manipulation commands need to be less picky...

			regards, tom lane

Sat, 17 Jun 2000 12:54:00 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: create user and transactions 