Referencing a column from another table in a different database with a foreign key constraint.
От | dan@binaryfrost.net (Dan S) |
---|---|
Тема | Referencing a column from another table in a different database with a foreign key constraint. |
Дата | |
Msg-id | 247f0de3.0305190339.6b131f99@posting.google.com обсуждение исходный текст |
Ответы |
Re: Referencing a column from another table in a different
|
Список | pgsql-sql |
I am trying to write a foreign key table constraint which references another column from a table in another database from within PostgreSQL. Within the database 'rsg_auth', there is a table called 'user_table' which has a column (amongst others) called 'username'. In another database called 'browser perm' I am trying to create the following: CREATE TABLE user_agreement ( ua_name VARCHAR(16) NOT NULL, ua_desc TEXT NOT NULL, sat_name VARCHAR(20) DEFAULT '', contract VARCHAR(30) DEFAULT '', filetype VARCHAR(30) NOT NULL, areacode VARCHAR(30) NOT NULL, nrt CHAR NOT NULL DEFAULT 'N' CONSTRAINT chkcons_nrt_y_n CHECK (nrt IN ('Y', 'N')), PRIMARY KEY (ua_name), CONSTRAINT fk_uaname_username FOREIGN KEY (ua_name) REFERENCES rsg_auth.user_table(username) ON UPDATE CASCADE ON DELETE CASCADE ) When I submitt it, I get the following error: ERROR: parser: parse error at or near "." Obviously this has something to do with my reference to the other table. Can anyone put my syntax straight please? Thanks in advance. -- Mr. Daniel J. Smale Remote Sensing Group Plymouth Marine Laboratory
В списке pgsql-sql по дате отправления: