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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026