| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Edwin Grubbs <egrubbs(at)rackspace(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: connecting inside pl/pgsql |
| Date: | 2002-09-17 14:42:58 |
| Message-ID: | 3D873F72.AB9A1A48@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton wrote:
>
> On Monday 16 Sep 2002 10:45 pm, Edwin Grubbs wrote:
> > Is there any way to connect to a different database inside a pl/pgsql
> > function? Apparently, this is possible in Oracle PL/SQL, and it would be
> > useful for porting that code.
> >
> > If it is not possible, are there any plans to add this?
>
> You should investigate the contrib/dblink directory in the source
> distribution.
It is possible in PL/TclU. There are currently no plans to add it
to PL/pgSQL.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2002-09-17 14:44:29 | advanced Apache authorization: updates triggered by select? |
| Previous Message | Andy Kriger | 2002-09-17 14:40:14 | Re: currval question |