On Tue, 2002-04-30 at 03:35, Bruce Momjian wrote:
>
> I think you have to use the backend pid to find your own. I think
> there is a libpq function that returns the backend pis so psql can
> frame the proper query.
Is anyoune working on information schema (or pg_xxx views) for use in
psql and other development frontends?
Also, are there plans to have SQL-accessible backend_pid function in the
backend by default ?
On RH 7.1 I can create it as:
CREATE FUNCTION getpid() RETURNS integerAS '/lib/libc.so.6','getpid'
LANGUAGE 'C';
But I'd like it to be a builtin from the start so one can query it
without relying on libpq
---------------------------------------------------------------------------
Hannu
