Quick Links

Cross database foreign keys

From:	Morgan Curley <mcurley(at)e4media(dot)com>
To:	"PostgreSQL-general" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject:	Cross database foreign keys
Date:	2001-07-06 13:30:02
Message-ID:	4.3.2.7.2.20010706092504.023823b8@e4media.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-novice pgsql-sql

Does anyone know if it is possible to connect to a differernt db from
within a plsql function.
I have multilple inter-related schemas and want to enforce some fk
relationships.

Thanks,
Morgan

In response to

Transactions within a function at 2001-07-06 12:40:08 from Daniel Åkerud

Responses

Re: [SQL] Cross database foreign keys at 2001-07-06 14:32:54 from Peter Eisentraut
Re: Cross database foreign keys at 2001-07-06 14:36:10 from Josh Berkus
Re: Cross database foreign keys at 2001-07-06 15:00:14 from Jan Wieck

Browse pgsql-general by date

	From	Date	Subject
Next Message	Doug McNaught	2001-07-06 13:32:28	Re: Transactions within a function
Previous Message	Jan Wieck	2001-07-06 13:23:36	Re: Transactions within a function

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Doug McNaught	2001-07-06 13:32:28	Re: Transactions within a function
Previous Message	Jan Wieck	2001-07-06 13:23:36	Re: Transactions within a function

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Doug McNaught	2001-07-06 13:32:28	Re: Transactions within a function
Previous Message	Jan Wieck	2001-07-06 13:23:36	Re: Transactions within a function