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:
> 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.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ If your life is a hard drive, Christ can be your backup. +
In response to
pgsql-docs by date
|Next:||From: Alvaro Herrera||Date: 2007-06-29 01:34:05|
|Subject: Re: proposed FAQ entry|
|Previous:||From: Neil Conway||Date: 2007-06-28 15:27:13|
|Subject: Re: rename of a view|