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

Thanks

Kay-Uwe

WEB.DE Video-Mail - Sagen Sie mehr mit bewegten Bildern   Informationen unter: http://freemail.web.de/?mc=021199