Reference pg_user ?

From: Carsten Zerbst <carsten(dot)zerbst(at)atlantec-es(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reference pg_user ?
Date: 2002-03-19 15:32:52
Message-ID: 1016551972.24953.7.camel@abulafia
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I need users and groups for an application and thought about
using ordinary postgres users and groups.

But I need some additional information like name, email-addres and the
like, so i tried to use something like:

test=# create table users (
test(# shortname name references pg_user,
test(# lastname varchar not null,
test(# email varchar not null
test(# );
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Referenced relation "pg_user" is not a table
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Referenced relation "pg_user" is not a table

Is it somehow possible to reference the system catalog with
the users ?

Thanks, Carsten

--
Dipl. Ing. Carsten Zerbst | carsten(dot)zerbst(at)atlantec-es(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-03-19 15:35:26 Re: multiple counts using CASE
Previous Message Andrew Sullivan 2002-03-19 15:28:42 Re: locking problems