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