From: | Gregory Scott WEBBER <gsw(at)students(dot)cs(dot)mu(dot)OZ(dot)AU> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: getting dbname through SPI |
Date: | 1998-10-13 08:17:29 |
Message-ID: | Pine.GSO.3.95.981013181355.25945B-100000@holly.cs.mu.OZ.AU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Lubelio Fernandes | 1998-10-13 13:30:25 | |
Previous Message | Gregory Scott WEBBER | 1998-10-13 07:00:37 | getting dbname through SPI |