Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] One SQL to access two databases.

From: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
To: Joe Conway <mail(at)joeconway(dot)com>,hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] One SQL to access two databases.
Date: 2002-11-30 12:19:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
On Friday 29 November 2002 17:14, Joe Conway wrote:
> pilsl(at)goldfisch(dot)at wrote:
> >>>Does anybody know if postgres support a SQL statement that handles two
> >>>diferent databases (in the same server)?
> >>
> >>Have a look at the contrib/dblink directory in the standard postgresql
> >>distro.
> >
> > Didnt find such a directory (or a similar one) in my 7.1.3-distri and
> > this would be very helpful to save db-handles in persistent programs.
> dblink was first released with PostgreSQL 7.2. But as of yesterday, a "new
> and improved" PostgreSQL 7.3 was released with a much improved dblink. If
> you can, upgrade to 7.3.
> Joe
Hi Joe !

	Now when the 7.3 release is out,can we get back to plpq ?
I did send You sources before vacation, and You said that You will take a 
	I hope I am not disturbing You. If You think that this is bad Idea, I give up 
hope that we merge this functions into dblink, an I will do it manually for 
my projects as I did before(I must say that this is a frustration for me 
because I must tweak the code with every new release of postgres).
	I am not using new plpq functions jet, so even if You do not want to merge,
maybe You can give me some comments(as I said before, I do not understand 
memory management and memory contests to well) ?
Thank You in advance.

Regards !

In response to


pgsql-hackers by date

Next:From: Horacio MirandaDate: 2002-11-30 14:54:11
Subject: about ODBC
Previous:From: Mike MascariDate: 2002-11-30 11:37:41
Subject: Re: Planning for improved versions of IN/NOT IN

pgsql-general by date

Next:From: pginfoDate: 2002-11-30 13:21:50
Subject: vacuum full analyze problem
Previous:From: snpeDate: 2002-11-30 11:31:07
Subject: Re: 7.4 Wishlist

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group