postgresql - @@SPID equivalent in Postgres -

-

is there equivalent @@spid in postgres or other way identify different connections same client process connected databases?

pg_backend_pid()

more details in manual: http://www.postgresql.org/docs/current/static/functions-info.html


Comments

Post a Comment

Popular posts from this blog

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2...
Read more

qt - Change color of QGraphicsView rubber band -

-
i know it's possible change color of rubber band rectangle way: qrubberband rubberband = new qrubberband(qrubberband::rectangle, this); qpalette pal; pal.setbrush(qpalette::highlight, qbrush(qt::white)); rubberband->setpalette(pal); but here way achieve rubber band, rendered qgraphicsview when rubberbanddrag mode active? or in "global scope"? i'm sorry wrote question, i've looked solution long time, , nothing. few minutes after asking, found solution setting stylesheet. i'm sharing it. just go designer of qt creator, click on canvas (qgraphicsview). in "qwidget" part find "stylesheet", edit it, , put like: selection-background-color: rgba(255, 255, 255, 128); that's :-). thanks.
Read more

c++ - Visible files in the "Projects" View of the Qt Creator IDE if using the CMake build system -

-
introduction i using integrated development environment (ide) qt creator v3.3.1 , build system cmake v3.2.1 develop in c++ programming language. currently implementing own custom build "framework", can use same cmake modules in each of projects. framework supports generation of source files corba , protocol buffers interface design language (idl) files, example. @ moment implementing support qt framework v5. the directory structure of projects follows (using convention on configuration ): ├── cmake # must contain source files of custom "cmake" │ # framework (usually shared directory). ├── config # may contain configuration files application. ├── doc # may contain documentation files. │   └── example # may contain .cc files example executables. ├── form # may contain "qt framework" .ui files. ├── idl # may contain corba .idl files. ├── include ...
Read more