Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Yeah, an extra fetch of the pg_class row doesn't seem all that nice.
>> I think you'd want to check it in approximately the same two places
>> where pg_class_ownercheck() is applied (one for the 1-xact and one for
>> the multi-xact path).
> Actually, the 1-xact path does not need it, because the check is already
Yeah, but if you do it there it's one added comparison
(isOtherTempNamespace is very cheap, and you can get the namespace
cheaply from the already-open rel). This way you need an extra syscache
lookup because you are insisting on doing the check in a place where you
don't have easy access to the pg_class row. Doesn't seem better.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Florian G. Pflug||Date: 2007-08-29 23:07:01|
|Subject: Re: int8 & INT64_IS_BUSTED|
|Previous:||From: Andrew Dunstan||Date: 2007-08-29 22:52:47|
|Subject: Re: [HACKERS] Contrib modules documentation online|
pgsql-admin by date
|Next:||From: Kevin Kempter||Date: 2007-08-30 12:47:35|
|Subject: transaction ID query|
|Previous:||From: Alvaro Herrera||Date: 2007-08-29 22:23:41|
|Subject: Re: reindexdb hangs|