Search Postgresql Archives

Re: Suggested way of associating PG user metadata with record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 20, 2009 at 12:28 PM, Peter Geoghegan
<peter.geoghegan86@xxxxxxxxx> wrote:
> Hello,
>
> I'd like to associate the PG user who created certain sorts of records
> with that record in my application. The obvious way to do this is by
> creating a text column with a default value of current_user in the
> record's table, or perhaps something similar with a trigger. However,
> because what I've described strikes me as a fairly common requirement,
> I suspect there may be a purpose-built, more direct and efficient
> feature I could use, such as a referential user datatype or something
> like that.
>
> Is there? If not, does the obvious approach seem reasonable?
>
> Regards,
> Peter Geoghegan
>

You should be careful about linking records to PostgreSQL user
accounts. If the PostgreSQL accounts are removed, there could be
problems with the foreign key references, if you don't implement it
carefully.

That said, you could also use the value in pg_user.usesysid as a
unique ID, rather than the account name (if you want to distinguish
between different users with the same login name, over a period of
time where users were removed and re-added).

http://www.postgresql.org/docs/8.2/interactive/view-pg-user.html

David.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux