Postgres Pro
Downloads
Home   >   mailing lists

Re: SessionID, pretty please - Mailing list pgsql-general

From Tom Lane
Subject Re: SessionID, pretty please
Date
Msg-id 859.1149798141@sss.pgh.pa.us
Whole thread Raw
In response to SessionID, pretty please  (tom.darci@gmail.com)
Responses Re: SessionID, pretty please
List pgsql-general
Tree view 
tom.darci@gmail.com writes:
>   My troubles would be solved if I could reference a SessionID from
> within PG. Any hope?

Create a sequence.  At session start, nextval() it to assign a session
ID for your session.  Then currval() returns your session ID whenever
you need it.

            regards, tom lane

pgsql-general by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: ERROR: for SELECT DISTINCT, ORDER BY expressions must
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: UTF8 problem