From: | "Thomas J Keller" <kellert(at)ohsu(dot)edu> |
---|---|
To: | "Postgresql PDX_Users" <pdxpug(at)postgresql(dot)org> |
Subject: | schema question |
Date: | 2007-05-12 00:19:47 |
Message-ID: | A60621DD-2FDE-468E-9E4E-83B003FB8BC3@ohsu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
Greetings,
I seem to have a misunderstanding about how to use schema:
corefacility=# SELECT admin.pi_contact.name_last, admin.fund_ohsu.alias
corefacility-# FROM admin.pi_contact, admin.fund_ohsu
corefacility-# WHERE admin.pi_contact.contact_id =
admin.fund.ohsu.pi_id;
ERROR: cross-database references are not implemented:
admin.fund.ohsu.pi_id
corefacility=# \d+ admin.fund_ohsu
Table "admin.fund_ohsu"
Column | Type |
Modifiers | Description
---------------+--------------
+---------------------------------------------------------------------
+-------------
fund_id | integer | not null default nextval
('"admin".fund_ohsu_fund_id_seq'::regclass) |
pi_id | integer
| |
alias | character(8) | not
null |
note | text
| |
date_created | date
| |
date_modified | date
| |
active | boolean | default
true |
Indexes:
"fund_id" PRIMARY KEY, btree (fund_id)
Foreign-key constraints:
"fund_ohsu_alias_fkey" FOREIGN KEY (alias) REFERENCES
"admin".coa_crosswalk(alias)
"fund_ohsu_pi_id_fkey" FOREIGN KEY (pi_id) REFERENCES
"admin".pi_contact(contact_id)
Has OIDs: no
So I don't understand why this select doesn't work.
What am I misunderstanding?
thanks,
Tom
kellert(at)ohsu(dot)edu
503-494-2442
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Lowry | 2007-05-12 03:05:46 | Re: schema question |
Previous Message | Rich Shepard | 2007-05-08 21:00:49 | SQL Query Help Needed |