schema question

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

Responses

Browse pdxpug by date

  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