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

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$ (view raw, whole thread or download thread mbox)
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

pgsql-interfaces by date

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

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