Обсуждение: Re : Global value/global variable?
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==
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
--
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 KhanMaranatha! <><
John McKown
John McKown