* Christoph Berg (c...@df7cb.de) wrote: > 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.
That's not currently exposed at an SQL level anywhere though, is it? Perhaps we should add a way to get that. Another thought would be to essentially expose 'log_line_prefix()' at the SQL level but I'm not sure that generally makes sense. We could also have an explicit function to get MyStartTime, similar to pg_backend_pid(). Thanks! Stephen
signature.asc
Description: Digital signature