Re: Schemas: status report, call for developers

On Thu, 2002-05-02 at 15:48, Tom Lane wrote:
> Hannu Krosing <hannu(at)tm(dot)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