Re: pgsql/src/backend/utils/adt (ri_triggers.c)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Peter Eisentraut - PostgreSQL <petere(at)hub(dot)org>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/src/backend/utils/adt (ri_triggers.c)
Date: 2000-09-26 05:05:20
Message-ID: 22197.969944720@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
>> When the RI triggers lock the PK table, temporarily switch the current user
>> id to the owner of the PK table, to avoid permission problems.

> Are there any changes for Stephan's question ?

> Stephan Szabo wrote:
>> As a question, since I don't have a source tree available here at work,
>> will there be an issue if an elog occurs between the various two user id
>> sets? Just wondering, because most of those statements are do some
>> SPI thing or elog.

It'll certainly be necessary for xact abort to restore the original
user ID setting. Peter, did you do that already?

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-09-26 05:42:15 pgsql/src/interfaces/ecpg/preproc (pgc.l)
Previous Message Hiroshi Inoue 2000-09-26 02:59:12 Re: pgsql/src/backend/utils/adt (ri_triggers.c)