Re: [ADMIN] Cannot reference system table

2002-10-21 Thread Tom Lane
Casey Allen Shobe <[EMAIL PROTECTED]> writes: > create table "schemes" ( > ... > "user_id" integer not null references "pg_user" ("usesysid"), > ... > ERROR: Referenced relation "pg_user" is not a table > As you can hopefully see, I need to reference the postgres user table >

[ADMIN] Cannot reference system table

2002-10-21 Thread Casey Allen Shobe
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