Hi Again,
After one of the guys working on this system poked around for a bit he
figured out that this piece of info was available in a global variable
called 'DatabaseName'. Unfortunately this couldn't be found in any docs.
Cheers,
Greg
> 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.