| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Constaints |
| Date: | 2004-12-05 21:40:45 |
| Message-ID: | 20041205214045.GA19853@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Dec 05, 2004 at 17:48:32 +0000,
Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> wrote:
> Would this be a postgresql session? If so how do I go about accessing it
> from a query/setting the value of it? I have looked at set authorization
> but I don't think this is where I should be looking!
At the start of each session you use an insert or update to update
the table with the values using the session id (process id) as the key.
Your views can refer to this table and the session id to get the appropiate
value.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Parnes | 2004-12-05 22:20:53 | Network authentication |
| Previous Message | Andrew M | 2004-12-05 21:10:42 | Re: SSL confirmation |