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
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? |