| 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: | Whole Thread | Raw Message | 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? |