On Thu, 2002-05-02 at 15:48, Tom Lane wrote:
> Hannu Krosing <hannu@tm.ee> writes:
> > On Thu, 2002-05-02 at 05:33, Tom Lane wrote:
> >> The temp schema is pg_temp_nnn where nnn is your BackendId (PROC array
> >> slot number). AFAIK there isn't any exported way to determine your
> >> BackendId from an SQL query.
>
> > The non-portable way on Linux RH 7.2 :
>
> >> create function getpid() returns int as '/lib/libc.so.6','getpid' language 'C';
>
> But PID is not BackendId.
Are you sure ?
I was assuming that BackendId was the process id of current backend
and that's what getpid() returns.
What is the Backend ID then ?
Is "PROC array slot number" something internal to postgres ?
-------------
Hannu