Create global variable in Postgresql

Question

I am creating trigger for log table. In that trigger i want to store xuserno to log table. xuserno is a argument of all function

example:

CREATE OR REPLACE FUNCTION fn_consume(xmode text, xuserno integer)
  RETURNS text AS
....
.....
.....

END;

Each table have this type of function. So how can i access the xuserno in my trigger. How can i create global variable for this purpose? or any other solution is have achive this?

Similar to stackoverflow.com/q/13172524/398670

Craig Ringer
– Craig Ringer

2013-04-02 06:27:17 +00:00
Commented Apr 2, 2013 at 6:27 — Craig Ringer
– Craig Ringer, Commented Apr 2, 2013 at 6:27

Community · Accepted Answer · 2017-05-23 12:22:04Z

1

It is possible to use transaction-local custom GUCs for this purpose but it's not usually a great idea.

In most cases it is preferable to just use an ON COMMIT DROP temporary table with a single row containing the value of interest.

See:

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Apr 2, 2013 at 6:23

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sathish Over a year ago

If am using like this set myapp.user_name=xuserno'; xuserno is argument of function. Using this for get value SELECT current_setting('myapp.user_name') but it show xuserno not a ` xuserno value ` why? Are anything am doing wrong

Craig Ringer Over a year ago

@SATSON From the information you've given I couldn't possibly say. Post a new question with the full code of the procedure in complete, runnable form along with your PostgreSQL version etc.

Collectives™ on Stack Overflow

Create global variable in Postgresql

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related