pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedForeign Key relationship between two databases
3+ messages / 3 participants
[nested] [flat]
* Foreign Key relationship between two databases
@ 2005-01-27 13:17 Sandeep Gaikwad <sgaikwad@vertex.co.in>
0 siblings, 2 replies; 3+ messages in thread
From: Sandeep Gaikwad @ 2005-01-27 13:17 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org
Hi,
I am using postgres 7.3.4. I am new to postgres.
I can give foreign key relationship between two tables of same database. Can I give foreign key relationship between tables of two databases ? Plz, let me know if possible & send me how can I do that?
Thanks & Regards,
Sandeep.
---------------------------------------------------------
Disclaimer:
The contents of this message are confidential and intended to the addressee at the specified e-mail address only. Its contents may not be copied or disclosed to anyone other than the intended recipient. If this e-mail is received in error, please contact Vertex Software Pvt. Ltd immediately on +91 20 4041500 with details of the sender and addressee and delete the e-mail. Vertex Software Pvt. Ltd accepts no responsibility in the event that the onward transmission, opening or use of this message and/or any attachments adversely affects the recipient's systems or data. It is the recipient's responsibility to carry out such virus and other checks as the recipient considers appropriate.
---------------------------------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Foreign Key relationship between two databases
@ 2005-01-27 13:35 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Sandeep Gaikwad <sgaikwad@vertex.co.in>
1 sibling, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2005-01-27 13:35 UTC (permalink / raw)
To: Sandeep Gaikwad <sgaikwad@vertex.co.in>; +Cc: pgsql-sql; pgsql-general@postgresql.org
On Thu, 27 Jan 2005, Sandeep Gaikwad wrote:
> I can give foreign key relationship between two tables of same
> database. Can I give foreign key relationship between tables of two
> databases ? Plz, let me know if possible & send me how can I do that?
Unfortunately, that's not really currently possible. You might be able to
fake some portion of it with custom triggers using dblink but I don't
think the locking would entirely work.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Foreign Key relationship between two databases
@ 2005-01-27 14:04 Dawid Kuroczko <qnex42@gmail.com>
parent: Sandeep Gaikwad <sgaikwad@vertex.co.in>
1 sibling, 0 replies; 3+ messages in thread
From: Dawid Kuroczko @ 2005-01-27 14:04 UTC (permalink / raw)
To: Sandeep Gaikwad <sgaikwad@vertex.co.in>; +Cc: pgsql-sql; pgsql-general@postgresql.org
On Thu, 27 Jan 2005 18:47:44 +0530, Sandeep Gaikwad
<sgaikwad@vertex.co.in> wrote:
> Hi,
> I am using postgres 7.3.4. I am new to postgres.
> I can give foreign key relationship between two tables of same database. Can I give foreign key relationship between tables of two databases ? Plz, let me know if possible & send me how can I do that?
Well... what you can do is replicate such table between two pg databases
using Slony-I and then use foreign key on this replicated table.
Regards,
Dawid
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-01-27 14:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-27 13:17 Foreign Key relationship between two databases Sandeep Gaikwad <sgaikwad@vertex.co.in>
2005-01-27 13:35 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2005-01-27 14:04 ` Dawid Kuroczko <qnex42@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox