Message-ID: <46850CF4.7050005@gardnerit.net>
Date: Fri, 29 Jun 2007 06:45:24 -0700
From: David Gardner <david@gardnerit.net>
User-Agent: Thunderbird 2.0.0.4 (Macintosh/20070604)
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: Re: proposed FAQ entry
References: <467C6DD9.3090407@gardnerit.net>
	<200706290106.l5T16KU18798@momjian.us>
	<20070629075509.GC20255@svr2.hagander.net>
In-Reply-To: <20070629075509.GC20255@svr2.hagander.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Well the motivation for the question, is to want to track edits to the 
database. To know who changed what/when, and possibly run a report 
against that information. I looked through the docs to find the user and 
session_user variables at:
http://www.postgresql.org/docs/8.1/interactive/functions-info.html

It just seemed natural to think there must be some kind of integer key 
associated with the user. Maybe this doesn't qualify as frequent.

Magnus Hagander wrote:
> On Thu, Jun 28, 2007 at 09:06:20PM -0400, Bruce Momjian wrote:
>> David Gardner wrote:
>>> Earlier today I was tempted to start storing usesysid's as foreign keys 
>>> in one of my tables by doing:
>>> SELECT usesysid FROM pg_user WHERE pg_user.usename= user;
>>>
>>> My proposed FAQ entry is based on this mailing list post which convinced 
>>> me not to:
>>> http://archives.postgresql.org/pgsql-novice/2005-04/msg00328.php
>>>
>>>
>>> So the Question would be:
>>>
>>> Q) How do I keep track of edits to a table? OR Can I use store usesysid 
>>> in my table to identify users?
>>>
>>> A) No because usesysid values are not guaranteed to remain the same 
>>> after a restore, or upgrade. Instead store the user name as text, if 
>>> needed create your own user table and associate the user names with 
>>> integer keys.
>> Uh, sorry, this is not a _frequent_ question/issue.
> 
> If it's not frequent, perhaps it should at least go in the documentatino
> somewhere?
> 
> (I confess I haven't checked if it's actually there already)
> 
> //Magnus
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq


-- 
David Gardner