Re: Temp tables are curious creatures....

Add to TODO:
* Add getpid() function to backend 
We have this in libpq, but it should be in the backend code as a
function call too.

---------------------------------------------------------------------------

Hannu Krosing wrote:
> 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 integer
>  AS '/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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026