Cannot reference system table

Поиск
Список
Период
Сортировка
От Casey Allen Shobe
Тема Cannot reference system table
Дата
Msg-id 200210212050.15495.cshobe@secureworks.net
обсуждение исходный текст
Ответы Re: Cannot reference system table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
create table    "schemes" (
    "id"        integer        not null unique default nextval('schemes_scheme_id_seq'),
    "user_id"    integer        not null references "pg_user" ("usesysid"),
    "scheme_name"    varchar(32)    not null unique,
    "expired"    boolean        not null default false,
    primary key    ("id")
);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'schemes_pkey'
for table 'schemes'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  Referenced relation "pg_user" is not a table

As you can hopefully see, I need to reference the postgres user table for data
integrity.  Can this be done?

Also, what can I do before creating the table to eliminate those notices?

Thanks,

--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
cshobe@secureworks.net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interesting date/time 60 second problem with Postgresql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cannot reference system table