"Functions and trigger procedures cannot start or commit transactions"

From: <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: "Functions and trigger procedures cannot start or commit transactions"
Date: 2001-03-09 23:59:06
Message-ID: 20010309235906.25231.qmail@mailhost.sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


It says in the Postgres docs for 7.0, "Functions and trigger
procedures cannot start or commit transactions and Postgres does not
have nested transactions."

Will it be possible for functions to start or commit transactions in
7.1? This would be an extremely useful feature to me. I'm trying to
get all of my operations written as pl/pgsql functions, but somethings
need to do transactions so they can do row-level locking. Maybe I'll
have to do that outside the function, though.

Thanks

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2001-03-10 02:02:38 Re: what's going on here?
Previous Message Sam and Lisa Snow 2001-03-09 23:49:23 RE: Postgresql.org website search