Re: SessionID, pretty please

From: "Tom D" <tom(dot)darci(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SessionID, pretty please
Date: 2006-06-08 21:40:24
Message-ID: 1149802824.246500.182550@y43g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thanks.

Tom Lane wrote:
> tom(dot)darci(at)gmail(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hugo 2006-06-08 21:48:16 psql command and file size
Previous Message Bjørn T Johansen 2006-06-08 21:32:45 Re: Best open source tool for database design / ERDs?