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)
Oct
9
awarded Student
Oct
9
comment Change existing column in PG to auto-incremental primary key
Ok, thanks. Can you just drop a note what does owned by measures.measure_id do?
Oct
9
asked Change existing column in PG to auto-incremental primary key
Oct
7
awarded Enlightened
Oct
7
awarded Nice Answer
Sep
30
awarded Popular Question
Sep
30
awarded Explainer
Sep
29
comment scite python import doesn't work
If you can't run Python script from SciTE or command shell, while you can run the script by double click in Explorer, means that Python is not set in your %PATH%. Your latter problem however doesn't seem to have any relation with SciTE, but with module you have problem with or perhaps with your whole Python setup.
Sep
28
comment How to convert DPI(Dots per Inch) of Camera images.?
DPI in image processing is like sampling rate in audio/video - you can upsample to 300 DPI, but that can't automagically reconstruct original image in 300 DPI, because that information is simply lost as you scanned at 72 DPI. So it wont help tesseract either.
Sep
27
accepted Migrating data from Python to PostGIS
Sep
27
comment Find correct SRID
Right, good catch... I didn't noticed that UNIT isn't closed. Thanks for confirmation.
Sep
27
comment Find correct SRID
I did what was most obvious to me and added new record for SRID 9001 to spatial_ref_sys column, afterwhich all seem to work as expected.
1 2 3 4 5