From: | Andreas <maps(dot)on(at)gmx(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: server variables ? |
Date: | 2007-04-12 17:56:39 |
Message-ID: | 461E72D7.4070701@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I've got a user table for my client application and the userid variable
I'd like to set would be a value of the primary-key column and those are
integers.
I'd rather store a numeric id than the current_user as a varchar for
efficiency reasons. Even a 1 byte integer would be enough.
A. Kretschmer schrieb:
> am Thu, dem 12.04.2007, um 5:33:30 +0200 mailte Andreas folgendes:
>
>> are there something like variables on the server-side that can be set by
>> the client?
>>
>> e.g. I'd like to store the user-id who created or updated a record.
>> I've allready got a trigger that sets a timestamp whenever a record is
>> updated. It was cute if I could let this triggers store the user-id, too.
>>
>
> If you mean with user-id the name of the current user, just use
> current_user.
>
>
>
>> I'd like to open a connection when the client application starts.
>> The client should set a variable userid within this connection and
>> every trigger would know who uses this connection right now.
>>
>> BTW ... How would I use this variable as a DEFAULT value when it should
>> be set just at the creation time of the record?
>> something like a collumn:
>> ...
>> created_by_fk integer not null default userid,
>>
> text default current_user
>
>
>
>
>> ...
>>
>> How could I use such a variables value in views?
>>
>
> select ... from your_view where created_by_fk = current_user
>
>
>
> Andreas
>
From | Date | Subject | |
---|---|---|---|
Next Message | John Koller | 2007-04-13 04:34:29 | Re: Install question |
Previous Message | psql-novice | 2007-04-12 16:41:37 | Re: Setting schema from command line in psql |