在Postgres中创建会话变量 [英] Creating a session variable in Postgres
问题描述
是否可以为Postresql中的每个用户创建会话变量?
Thx
< blockquote> 2004年6月2日星期三16:00:18 +0200
" Nagib Abi Fadel" < NA ************* @ usj.edu.lb>写道:
是否有可能为Postresql中的每个用户创建一个会话变量?
我只是在想术语会话变量就像爱这个词一样在
中,这意味着每个人都有所不同。
话虽如此,我无法想到会话变量的任何定义。那个
Postgres无法处理。如果你有一个更具体的意思,你想要询问,我建议提供一个场景,或者更具体的
问题。
-
Bill Moran
潜在技术
http://www.potentialtech.com
-------------------- -------(广播结束)---------------------------
提示4:不要杀了-9''邮政局长
Nagib Abi Fadel写道:是否可以创建$在Postresql中的每个用户的会话变量??
编号你可以做的最好的事情就是创建一个临时表并将值放入
那里。
-
Bruce Momjian | http://candle.pha.pa.us
pg *** @ candle.pha.pa.us | (610)359-1001
+如果你的生活是硬盘,|罗伯茨路13号
+基督可以成为你的备份。 |宾夕法尼亚州新城广场19073年
---------------------------(播出结束) - --------------------------
提示9:如果您的计划者忽视您选择索引扫描的愿望
加入列的数据类型不匹配
Bruce Momjian写道:Nagib Abi Fadel写道:
是否可以为Postresql中的每个用户创建一个会话变量??
否。你能做的最好的是创建临时表并在其中放置一个值。
我是否正确地假设'将通过OID燃烧
虽然(对于有很多短会话的网络应用可能是一个问题)。
-
Richard Huxton
Archonet Ltd
---------------------------(播出结束) ---------------------------
提示8:解释分析是你的朋友
Is it possible to create a session variable for each user in Postresql ??
Thx
On Wed, 2 Jun 2004 16:00:18 +0200
"Nagib Abi Fadel" <na*************@usj.edu.lb> wrote:
Is it possible to create a session variable for each user in Postresql ??
I was just thinking that the term "session variable" is like the word "love" in
that it means something different to everyone.
That being said, I can''t think of any definition of "session variable" that
Postgres isn''t capable of handling. If you have a more specific meaning you
want to ask about, I suggest providing a scenerio, or otherwise more specific
question.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
Nagib Abi Fadel wrote:Is it possible to create a session variable for each user in Postresql ??
No. The best you can do is create a temp table and put a value in
there.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
Bruce Momjian wrote:Nagib Abi Fadel wrote:Is it possible to create a session variable for each user in Postresql ??
No. The best you can do is create a temp table and put a value in
there.
Would I be right in assuming that''s going to be burning through OIDs
though (possibly an issue for a web-app with lots of short sessions).
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
这篇关于在Postgres中创建会话变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!