Re: Durumdara 2016-04-09 <caecmxhkyummt3wiknywwsk1xv3gfot46aotm+6jxwhya3dg...@mail.gmail.com> > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general