Обсуждение: Re : Global value/global variable?

Поиск
Список
Период
Сортировка

Re : Global value/global variable?

От
Edson Richter
Дата:
PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMHB0OyI+PHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJn
aW4tYm90dG9tOjA7Ij5ZZXMuIEl0J3Mgc2ltaWxhciwgYnV0IGNvbnNpZGVyIEknbSB1c2luZyBh
IGNvbm5lY3Rpb24gcG9vbCwgc28gSScndmUgbm8gY29udHJvbCBvbiB3aGVuIHRoZSBjb25uZWN0
aW9ucyBhcmUgZXN0YWJsaXNoZWQvZGVzdHJveWVkLjwvcD48cCBzdHlsZT0ibWFyZ2luLXRvcDow
O21hcmdpbi1ib3R0b206MDsiPkkgdGhpbmsgSSBuZWVkIHNvbWV0aGluZyB3aXRoIHNjb3BlIGJy
b2FkZXIgdGhhbiBzZXNzaW9uLi4uPC9wPjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJv
dHRvbTowOyI+Jm5ic3A7PC9wPjxkZXYzX2pqeT5BdGVuY2lvc2FtZW50ZSw8YnI+PGJyPkVkc29u
IFJpY2h0ZXImbmJzcDs8L2RldjNfamp5Pjxicj48YnI+LS0tLS0tIE1lbnNhZ2VtIG9yaWdpbmFs
IC0tLS0tLTxicj48Yj5EZTombmJzcDs8L2I+Sm9obiBNY0tvd248am9obi5hcmNoaWUubWNrb3du
QGdtYWlsLmNvbT48YnI+PGI+RGF0YTombmJzcDs8L2I+MTkvMDYvMjAxNCA4aDQ0PGJyPjxiPlBh
cmE6Jm5ic3A7PC9iPkVkc29uIFJpY2h0ZXI7PGJyPjxiPkFzc3VudG86PC9iPlJlOiBbR0VORVJB
TF0gR2xvYmFsIHZhbHVlL2dsb2JhbCB2YXJpYWJsZT88YnI+PGJyPjxkaXYgZGlyPSJsdHIiPkEg
cHNxbCBzZXNzaW9uIGlzIHNob3duIGJlbG93OjxkaXY+PGJyPjwvZGl2PjxkaXY+PGRpdj50c2gw
MDk9IyBcc2V0IGxwYXIgJ1wnTElIMVwnJzwvZGl2PjxkaXY+dHNoMDA5PSMgc2VsZWN0ICogZnJv
bSBjYXBwZWQgd2hlcmUgbHBhcj06bHBhciBsaW1pdCA1OzwvZGl2PjxkaXY+Jm5ic3A7bHBhciB8
ICZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO3N0YXJ0ZWQgJm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7fCAmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDtlbmRlZCAmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDs8L2Rpdj4NCjxkaXY+LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t
LS0tLS0tLS08L2Rpdj48ZGl2PiZuYnNwO0xJSDEgfCAyMDE0LTA2LTA5IDIxOjU3OjEzIHwgMjAx
NC0wNi0wOSAyMjoyMToyMTwvZGl2PjxkaXY+Jm5ic3A7TElIMSB8IDIwMTQtMDYtMDkgMjI6NDI6
MTIgfCAyMDE0LTA2LTA5IDIzOjA2OjIyPC9kaXY+PGRpdj4mbmJzcDtMSUgxIHwgMjAxNC0wNi0w
OSAyMzoyMjoxMiB8IDIwMTQtMDYtMDkgMjM6Mzk6MTI8L2Rpdj4NCjxkaXY+Jm5ic3A7TElIMSB8
IDIwMTQtMDYtMDkgMjM6NTI6MTIgfCAyMDE0LTA2LTEwIDAwOjAxOjIxPC9kaXY+PGRpdj4mbmJz
cDtMSUgxIHwgMjAxNC0wNi0xMCAwMTowNzoxMSB8IDIwMTQtMDYtMTAgMDE6MDc6NTE8L2Rpdj48
ZGl2Pig1IHJvd3MpPC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRp
dj5JcyB0aGlzIGNsb3NlIHRvIHdoYXQgeW91IGFyZSBsb29raW5nIGZvcj88L2Rpdj4NCjwvZGl2
PjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48YnI+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3Rl
Ij5PbiBXZWQsIEp1biAxOCwgMjAxNCBhdCA5OjUwIFBNLCBFZHNvbiBSaWNodGVyJm5ic3A7PHNw
YW4gZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86ZWRzb25yaWNodGVyQGhvdG1haWwuY29t
IiB0YXJnZXQ9Il9ibGFuayI+ZWRzb25yaWNodGVyQGhvdG1haWwuY29tPC9hPiZndDs8L3NwYW4+
IHdyb3RlOjxicj4NCjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdp
bjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgi
Pg0KDQoNCjxkaXY+PGRpdiBkaXI9Imx0ciI+SXQgaXMgcG9zc2libGUgdG8gZGVmaW5lIGEgZ2xv
YmFsIHZhbHVlL3ZhcmlhYmxlIGluIFBvc3RncmVTUUwgaW4gYSB3YXkgdGhhdCBJIGNhbiB1c2Ug
aXQgaW4gYW55IHF1ZXJ5L3ZpZXcvZnVuY3Rpb24/PGRpdj5Gb3IgZXhhbXBsZSwgSSBkbyBoYXZl
IGEgY29ubmVjdGlvbiBzdHJpbmcgSSB1c2UgZm9yIGRibGluayBjb25uZWN0aW9ucyBpbiBzZXZl
cmFsIHBsYWNlcyAoc3BlY2lhbGx5LCBpbnNpZGUgdmlld3MpLjwvZGl2Pg0KPGRpdj5UaGVuLCBp
ZiBJIHdhbnQgdG8gY2hhbmdlIHRoZSBjb25uZWN0aW9uIHN0cmluZywgSSBkbyBoYXZlIHRvIGNo
YW5nZSBldmVyeSB2aWV3IG1hbnVhbGx5LjwvZGl2PjxkaXY+SWYgSSBjYW4gc2V0IGEga2luZCBv
ZiBnbG9iYWwgdmFyaWFibGUsIHRoZW4gSSBqdXN0IHVzZSBpdCBpbnNpZGUgZXZlcnkgdmlldyAt
IHRoZW4sIGF0IG15IGFwcGxpY2F0aW9uIHN0YXJ0dXAgKG9yIGV2ZW4gYXQgUG9zdGdyZVNRTCBz
dGFydHVwLCBpZiBJIGNhbiBzZXQgdGhpcyBzdHJpbmcgYXQgcG9zdGdyZXNxbC5jb25mIGxldmVs
KSwgd291bGQgc2V0IHRoaXMgJnF1b3Q7Z2xvYmFsIHZhcmlhYmxlJnF1b3Q7IHRvIHBvaW50IHRo
ZSBjdXJyZW50IHN0cmluZy48L2Rpdj4NCjxkaXY+PGJyPjwvZGl2PjxkaXY+WW91ciBlbmxpZ2h0
bWVudCB3aWxsIGJlIHJlYWxseSB3ZWxjb21lLjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+UmVn
YXJkcyw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkVkc29uPC9kaXY+PGRpdj48YnI+PC9kaXY+
IAkJIAkgICAJCSAgPC9kaXY+PC9kaXY+DQo8L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPjxiciBjbGVh
cj0iYWxsIj48ZGl2Pjxicj48L2Rpdj4tLSA8YnI+PGRpdiBkaXI9Imx0ciI+PGRpdj5UaGVyZSBp
cyBub3RoaW5nIG1vcmUgcGxlYXNhbnQgdGhhbiB0cmF2ZWxpbmcgYW5kIG1lZXRpbmcgbmV3IHBl
b3BsZSE8YnI+PC9kaXY+R2VuZ2hpcyBLaGFuPGJyPjxkaXY+PGJyPjxkaXY+PGRpdj48ZGl2Pk1h
cmFuYXRoYSEgJmx0OyZndDsmbHQ7PGJyPg0KSm9obiBNY0tvd248YnI+PC9kaXY+PC9kaXY+PC9k
aXY+PC9kaXY+PC9kaXY+DQo8L2Rpdj4NCg0KPC9zcGFuPg==

Re: Re : Global value/global variable?

От
Edson Richter
Дата:
I've ended creating a table to store database parameters, and using a subquery, I can achieve the "global variable" effect.

Thanks for your insight,

Edson.

From: edsonrichter@hotmail.com
To: pgsql-general@postgresql.org
Subject: Re : [GENERAL] Global value/global variable?
Date: Thu, 19 Jun 2014 14:39:45 +0000

Yes. It's similar, but consider I'm using a connection pool, so I''ve no control on when the connections are established/destroyed.

I think I need something with scope broader than session...

 Atenciosamente,

Edson Richter 

------ Mensagem original ------
De: John McKown
Data: 19/06/2014 8h44
Para: Edson Richter;
Assunto:Re: [GENERAL] Global value/global variable?

A psql session is shown below:

tsh009=# \set lpar '\'LIH1\''
tsh009=# select * from capped where lpar=:lpar limit 5;
 lpar |       started       |        ended        
------+---------------------+---------------------
 LIH1 | 2014-06-09 21:57:13 | 2014-06-09 22:21:21
 LIH1 | 2014-06-09 22:42:12 | 2014-06-09 23:06:22
 LIH1 | 2014-06-09 23:22:12 | 2014-06-09 23:39:12
 LIH1 | 2014-06-09 23:52:12 | 2014-06-10 00:01:21
 LIH1 | 2014-06-10 01:07:11 | 2014-06-10 01:07:51
(5 rows)


Is this close to what you are looking for?


On Wed, Jun 18, 2014 at 9:50 PM, Edson Richter <edsonrichter@hotmail.com> wrote:
It is possible to define a global value/variable in PostgreSQL in a way that I can use it in any query/view/function?
For example, I do have a connection string I use for dblink connections in several places (specially, inside views).
Then, if I want to change the connection string, I do have to change every view manually.
If I can set a kind of global variable, then I just use it inside every view - then, at my application startup (or even at PostgreSQL startup, if I can set this string at postgresql.conf level), would set this "global variable" to point the current string.

Your enlightment will be really welcome.

Regards,

Edson




--
There is nothing more pleasant than traveling and meeting new people!
Genghis Khan

Maranatha! <><
John McKown