pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSybase Connection_Property('number') equivalent in PostGre ?
2+ messages / 2 participants
[nested] [flat]
* Sybase Connection_Property('number') equivalent in PostGre ?
@ 2005-12-02 09:04 Emil Rachovsky <zsevgymko@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Emil Rachovsky @ 2005-12-02 09:04 UTC (permalink / raw)
To: pgsql-sql
I am trying to find out the PostGre equivalent to
the Sybase function Connection_Property (which returns
the connection id, given the parameter 'number') ,but
without success so far. Can anyone tell me how to
retrieve the connection id in PostGre?
Thanks in advance,
Emil
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sybase Connection_Property('number') equivalent in PostGre
@ 2005-12-02 10:36 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Emil Rachovsky <zsevgymko@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Achilleus Mantzios @ 2005-12-02 10:36 UTC (permalink / raw)
To: Emil Rachovsky <zsevgymko@yahoo.com>; +Cc: pgsql-sql
O Emil Rachovsky Ýãñáøå óôéò Dec 2, 2005 :
>
> I am trying to find out the PostGre equivalent to
> the Sybase function Connection_Property (which returns
> the connection id, given the parameter 'number') ,but
> without success so far. Can anyone tell me how to
> retrieve the connection id in PostGre?
> Thanks in advance,
> Emil
I think pg_backend_pid() and pg_stat_get_backend_pid(integeger)
are your best bets.
>
>
>
> __________________________________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
-Achilleus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-12-02 10:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-02 09:04 Sybase Connection_Property('number') equivalent in PostGre ? Emil Rachovsky <zsevgymko@yahoo.com>
2005-12-02 10:36 ` Re: Sybase Connection_Property('number') equivalent in PostGre Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox