Re: Durumdara 2016-04-09 <CAEcMXhkyUMmT3wiKnyWwSK1Xv3gFot46AoTM+6JxWhya3dGWjg@xxxxxxxxxxxxxx> > In MS the session id is smallint, so it can repeats after server restarts, > but my coll. found a "session creation timestamp". > This is a key which unique. > With this we can check for died sessions and we can clean their records. > > We want create same mechanism. > I know there are adv. locks in PG, but I want to use session id. > > This could be: > pg_backend_pid() > > May pid repeats. > Where I can get timestamp or some other unique data with I can create a > combined primary key? Btw, what you are describing is exactly what %c in log_line_prefix does. Christoph -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
