<html><style>p {margin: 0px}</style><body bgcolor='#ffffff' style='font-size:9pt; font-family:Verdana; font-family: Verdana' ><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 done by starting postgres in single-user mode, with correct<BR>options.<BR><BR>my guess is that this should only be done by someone who knows what he is<BR>doing.<BR><BR>gnari<BR><BR>Hi @ all, hi gnari,</P><P> </P><P>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. </P><P> </P><P>But the system say, that the table is an system table an I can't create the Key.</P><P> </P><P>Have anybody an solution?</P><P> </P><P>Thanks</P><P> </P><P>Kay-Uwe<BR><BR></P><br><br><table cellpadding="0" cellspacing="0" border="0"><tr><td bgcolor="#000000"><img src="http://img.web.de/p.gif" width="1" height="1" border="0" alt="" /></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></body></html>
