Connect within a db function

From: "Joonas Makkonen" <joonas(dot)makkonen(at)infosto(dot)fi>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Connect within a db function
Date: 2000-08-14 17:33:04
Message-ID: 01aa01c00615$b4626100$e62689c2@infosto.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Is it possible to connect to another db in a function called from sql.

ie. SELECT foobar(args) FROM dummy;

where foobar is a function that makes a connection to another db and does a
few things. The problem is that when ever the function makes a connection
the backend dies violently. Is this a bug or is such behaviour forbidden?
The function is written in C. When tested in a separate program it works
just fine.

Joonas Makkonen

Browse pgsql-interfaces by date

  From Date Subject
Next Message John David Garza 2000-08-14 18:08:27 Re: Migration
Previous Message Peter Mount 2000-08-14 07:17:02 RE: Large objects with JDBC