Is there a way in such function find out the real current user?
CURRENT_USER should be right. SESSION_USER is the username that
connected to the DB. Look at table 6-27, session information
functions:
http://www.postgresql.org/docs/7.3/static/functions-misc.html
-sc
--
Sean Chittenden
on a backup db until you're 100% good to go. -sc
--
Sean Chittenden
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
balance float not null,
primary key(transaction_id)
);
Once you insert a value into the bank_account table, SELECT
CURRVAL('transaction_id_seq') will be what you're looking for. Read
up on CURRVAL() at:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functio
anyway. I believe you can
> do it in pltcl though.
If you're shopping around for pl languages, pl/ruby fits the bill too.
Reflective language with dynamic execution. -sc
http://moulon.inra.fr/ruby/plruby.html
--
Sean Chittenden
---(end of broadcast)--
