Thread: Re: Where are all the users?

Re: Where are all the users?

From
"Kay-Uwe Genz"
Date:
<p><style>p {margin: 0px}</style>><br />> But pg_user is a view and cant referenced. So I try to use
pg_shadow,<br/>> but PG say that this is an System table and I cant use it.<br /><br />so you real question is
probably:<br/>how can i modify the structure of system tables ?<br /><br />you do not say what your ultimate purpose
is,so I cannot see if the<br />FOREIGN KEY reference is necessary, but if you really need it, it possibly<br />might be
doneby starting postgres in single-user mode, with correct<br />options.<br /><br />my guess is that this should only
bedone by someone who knows what he is<br />doing.<br /><br />gnari<br /><br />Hi @ all, hi gnari,<p> <p>I'm sorry
aboutmy unspecified question. Second try. I want to use the User-ID from the system-Tables to identify a user. I have a
table"journal" where I save dataset about transactions inside my A! pplication (like change datas, insert, ...) and I
needInformation, who does this actions. Because the Database Users are the same as the Applikation users, I thing it is
agood solution, to user the System-Information and user the userid from pg_user (or pg_shadow - that the table) as an
foreignkey. <p> <p>But the system say, that the table is an system table an I can't create the Key.<p> <p>Have anybody
ansolution?<p> <p>Thanks<p> <p>Kay-Uwe<br /><br /><br /><br /><table border="0" cellpadding="0" cellspacing="0"><tr><td
bgcolor="#000000"><imgalt="" border="0" height="1" src="http://img.web.de/p.gif" width="1" /></td></tr><tr><td
style="font-family:verdana;font-size:12px; line-height:17px;">WEB.DE Video-Mail - Sagen Sie mehr mit bewegten
Bildern  <br/>Informationen unter: <a
href="http://freemail.web.de/?mc=021199"><b>http://freemail.web.de/?mc=021199</b></a>  </td></tr></table>

Re: Where are all the users?

From
Robert Treat
Date:
On Tue, 2004-08-03 at 05:57, Kay-Uwe Genz wrote:

>
> But pg_user is a view and cant referenced. So I try to use pg_shadow,
> but PG say that this is an System table and I cant use it.

so you real question is probably:
how can i modify the structure of system tables ?

you do not say what your ultimate purpose is, so I cannot see if the
FOREIGN KEY reference is necessary, but if you really need it, it
possibly
might be done by starting postgres in single-user mode, with correct
options.

my guess is that this should only be done by someone who knows what he
is
doing.

gnari

Hi @ all, hi gnari,



I'm sorry about my unspecified question. Second try. I want to use the
User-ID from the system-Tables to identify a user. I have a table
"journal" where I save dataset about transactions inside my A!
pplication (like change datas, insert, ...) and I need Information, who
does this actions. Because the Database Users are the same as the
Applikation users, I thing it is a good solution, to user the
System-Information and user the userid from pg_user (or pg_shadow - that
the table) as an foreign key.



But the system say, that the table is an system table an I can't create
the Key.



Have anybody an solution?

I think the way you are "supposed to do this" is by using the
CURRENT_USER variable to get the current user name for the person
connected. If you are stuck on using the system id's you could create
your own triggers to verify the entry in pg_user.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL