2d
awarded Enlightened
2d
awarded Nice Answer
Nov
21
awarded Supporter
Nov
13
awarded Nice Question
Nov
10
answered Wine ODBC connection to local PostgreSQL database
Nov
9
asked Wine ODBC connection to local PostgreSQL database
Nov
6
awarded Popular Question
Nov
5
awarded Good Question
Oct
30
awarded Notable Question
Oct
27
comment How can I move all the window controls to the right (or left)?
Hardcoding these buttons on the left side is bad news for regular right handed user. I like Dash functionality, and won't go back because of these buttons, but it's just yet another stupid decision toward blindly copying OSX design - copycats.
Oct
23
asked Buildout Virtualenv IPython SublimeRepl
Oct
23
comment How to associate a file with a program installed in wine
There is no need for so much backslash escapes - just wrap the path in double quotes without any escaping
Oct
12
awarded Yearling
Oct
12
awarded Yearling
Oct
12
accepted Retrieve index column
Oct
11
comment Retrieve index column
How to get it programatically (i.e. with sql query). SELECT * FROM sqlite_master WHERE type='index' gives me the indexes, but I further need columns referenced.
Oct
11
asked Retrieve index column
Oct
9
awarded Scholar
Oct
9
accepted Change existing column in PG to auto-incremental primary key
Oct
9
comment Change existing column in PG to auto-incremental primary key
Ah, all right it's just like a decoration. I mentioned that table already has data, but newly created sequence wont respect already present data and will start counting from 1, which will error on first new insert for unique constraint. So if anyone else is reading this it's more correct to use CREATE SEQUENCE seq START WITH x where x is last row (SELECT MAX(measure_id)+1 FROM measures in my case)
1 2 3 4 5