Lists: | pgsql-general |
---|
From: | "Kay-Uwe Genz" <kay-uwe(dot)genz(at)web(dot)de> |
---|---|
To: | "gnari" <gnari(at)simnet(dot)is> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Where are all the users? |
Date: | 2004-08-02 08:21:21 |
Message-ID: | 625626261@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
<html><style>p {margin: 0px}</style><body bgcolor='#ffffff' style='font-size:9pt; font-family:Verdana; font-family: Verdana' ><STYLE>p {margin: 0px}</STYLE><P>"gnari" <gnari(at)simnet(dot)is> schrieb am 01.08.04 19:11:26:<BR><BR>From: "Kay-Uwe.Genz" <kay-uwe(dot)genz(at)web(dot)de><BR>> <BR>> Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:<BR>> <BR>> > Hi @ all,<BR>> ><BR>> > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of <BR>> > my DB. But I saw that pg_user is a view. Where are the information I <BR>> > need?<BR><BR>template1=# d pg_user<BR><BR>gnari<BR><BR>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.</P><P>Kay-Uwe Genz<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;">Verschicken Sie romantische, coole und witzige Bilder per SMS! <br>Jetzt neu bei WEB.DE FreeMail: <A HREF="http://freemail.web.de/?mc=021193"><B>http://freemail.web.de/?mc=021193</B></A> </td></tr></table></body></html>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 1.2 KB |
From: | "gnari" <gnari(at)simnet(dot)is> |
---|---|
To: | "Kay-Uwe Genz" <kay-uwe(dot)genz(at)web(dot)de> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Where are all the users? |
Date: | 2004-08-02 12:37:59 |
Message-ID: | 006c01c4788d$8b300b40$0100000a@wp2000 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
"Kay-Uwe Genz" <kay-uwe(dot)genz(at)web(dot)de> :
> "gnari" <gnari(at)simnet(dot)is> schrieb am 01.08.04 19:11:26:
>
> From: "Kay-Uwe.Genz" <kay-uwe(dot)genz(at)web(dot)de>
> >
> > Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:
> >
> > > Hi @ all,
> > >
> > > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of
> > > my DB. But I saw that pg_user is a view. Where are the information I
> > > need?
>
> template1=# d pg_user
>
> gnari
>
> 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