Bruce Momjian wrote:
> Tom Lane wrote:
> > Andrew Dunstan <[EMAIL PROTECTED]> writes:
> > > Could we maybe have some flavor of ROLLBACK that doesn't issue a warning 
> > > if no transaction is in progress? There is precedent for this sort of 
> > > facility - DROP ... IF EXISTS.
> > 
> > Something that would actually be doable for 8.3 would be to downgrade
> > this particular WARNING to a NOTICE.  A DBA who hasn't got
> > log_min_messages set higher than NOTICE hasn't really got a lot of room
> > to whine about bulky logs.
> I have developed the attached patch to implement this.  I assume we want
> to change ABORT outside a transaction from WARNING to NOTICE, but not

Patch applied:
        test=> ROLLBACK;
        NOTICE:  there is no transaction in progress

Commit is unchanged:

        test=> COMMIT;
        WARNING:  there is no transaction in progress

  Bruce Momjian  <[EMAIL PROTECTED]>

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to