<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>
