On Thu, 2002-05-02 at 15:48, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
