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

getting dbname through SPI

From: Gregory Scott WEBBER <gsw(at)students(dot)cs(dot)mu(dot)OZ(dot)AU>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: getting dbname through SPI
Date: 1998-10-13 07:00:37
Message-ID: Pine.GSO.3.95.981013163641.8303A-100000@holly.cs.mu.OZ.AU (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi All,

Is it possible to get the dbname via SPI?  The situation is as that from
many trigger functions our package installs on tables with a db, an
external daemon is contacted with some information about particular
transactions that have taken place.  In the situation where multiple
(similarly configured) databases are simultaneously live it is imperative
that the database in which the trigger was fired is known (by name) so the
aforementioned daemon can deal with the incoming information properly.

Thanks in advance,

Greg


Responses

pgsql-interfaces by date

Next:From: Gregory Scott WEBBERDate: 1998-10-13 08:17:29
Subject: Re: getting dbname through SPI
Previous:From: brianDate: 1998-10-13 03:18:13
Subject: Re: pgsql-interfaces-digest V1 #105

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