cygwin: create function getpid (backend process id) - equivalent to MS SQL Server SPID ?

From: Cédric Dufour <cedric(dot)dufour(at)freesurf(dot)ch>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: cygwin: create function getpid (backend process id) - equivalent to MS SQL Server SPID ?
Date: 2002-07-30 12:02:34
Message-ID: NDBBIFNBODNADCAOFDOAAEINCDAA.cedric.dufour@freesurf.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Could anyone confirm that the returned value from the function below behaves
the same way as MS SQL Server @@SPID variable and that it remains unchanged
and unique throughout a connection ?

create function getpid() returns int as '/bin/cygwin1.dll' language 'c';
select getpid();

Thanx a lot.

Cédric Dufour

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2002-07-30 19:55:21 Re: Postgres
Previous Message Jason Tishler 2002-07-26 15:33:43 Re: Running PostgreSQL as a service under Windows XP Pro