references to variable in another schema

From: Mija Lee <mija(at)scharp(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: references to variable in another schema
Date: 2007-11-09 17:48:52
Message-ID: 47349D84.7090902@scharp.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi folks:

I wanted to put a reference on a table in the public schema that
references a column in a table in another schema. I tried:

create table cellphone(emplid integer not null references
admin.tbl_employee.employee_id);

ERROR: cross-database references are not implemented:
"admin.tbl_employee.employee_id"

But these are within one database. Is there a way to do this or have I
gotten my syntax messed up?

Mija

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-11-09 17:52:47 Re: references to variable in another schema
Previous Message Kasia Tuszynska 2007-11-09 17:06:36 Autovacuum - what does it actually do?