Re: Schemas: status report, call for developers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Schemas: status report, call for developers
Date
Msg-id 7032.1020347305@sss.pgh.pa.us
Whole thread Raw
In response to Re: Schemas: status report, call for developers  (Hannu Krosing <hannu@tm.ee>)
Responses Re: Schemas: status report, call for developers  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: PostgreSQL mission statement?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Re : Solaris Performance - 64 bit puzzle