Re: One more question regarding dblink

On 16 Apr 2003 at 9:19, Joe Conway wrote:

> Shridhar Daithankar wrote:
> > Is there an equivalent of .profile/.logout per database/per schema/per table
> > in postgresql? That should be an ideal place to put a database link
> > initiation/termination.
>
> As Tom has mentioned within the last day or two, the right answer is not
> to emulate Oracle, but instead to implement external data access per the
> SQL-MED spec. That has been discussed at some length in the past --
> search the archives. As it is not a small undertaking, and I had other
> higher personal priorities during this release cycle, it will not happen
> for 7.4. Perhaps I'll take it on for 7.5 (but then again, perhaps not).

I agree that standards should be done. But if it is question of providing
transparent remote database objects with SQL-MED not even being on drawing
board, I would not mind a postgresql way of doing it. Something is better than
nothing.

Bye
Shridhar

--
Marriage, n.: The evil aye.