Referencing columns from system tables possible?

From: Boris Popov <boris(at)procedium(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Referencing columns from system tables possible?
Date: 2003-11-08 02:20:32
Message-ID: 182378185782.20031107182032@procedium.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello pgsql-general,

When trying to create a table

CREATE TABLE sessions (
id serial PRIMARY KEY,
procpid int4 REFERENCES pg_listener(listenerpid) ON DELETE CASCADE
);

I get a warning saying 'relation "pg_listener" is a system catalog'

Is it unreasonable and/or impossible to do this?

--
-Boris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-11-08 03:25:33 Re: Referencing columns from system tables possible?
Previous Message Alvaro Herrera 2003-11-08 01:54:02 Re: Recovery Data Cant Be!!!