I am trying to import a shapefile using db manager to postgresql. My shapefile has OBJECTID (PRIMARY KEY), ID (STRING FIELD eg: 2543-96-7948 )and several other attributes of type string. When importing I get the following error.  When I import using postgis shapefile import/export manager, I got no errors and the shapefile uploaded successfully. I think qgis is assuming my primary key to be ID field when it is actually OBJECTID. How to change this? I tried using the primary key field in input table and set it to id but got same error. Does it create new field or is it selecting a column from the attribute table? looked up for answers  but was not enough to resolve my issue.
I have a shapefile with a "id" field in which some non-unique ID numbers exist (don't ask).  When I try to import this to a PostGIS database using QGIS' DB Manager, it tries to re-use those IDs are unique primary key and fails.  The "Primary key" option is not ticked. "id" is shown in grey next to it.   How can I make DB Manager ignore an existing "id" column and just create a new SERIAL field or something like that?  QGIS 2.18.
Currently my bibliography says "Literatur" (german). But I want something completely different there. How can I achieve that? Avoid linebreaks in LaTeX console / log output (or increase columns in terminal) Is it possible to tell the LaTeX command not to use line breaks in its console / log output?  This would make it easier to automate the processing of the log file, e.g. extracting the names of missing graphics files like in this output  ! LaTeX Error: File `figures/triggers/muontriggers/notmu18_medium_mu10_loose/2d map_abs_eta_phi.pdf' not found.   which are otherwise cut into pieces and unnecessarily difficult to grep etc. I lost my house in minecraft. How can I find it? I was in creative mode on minecraft PE. I made this really awesome house plus a hotel! I was finishing up my house but decided to explore first. I explored for about 10 minutes and then stopped. Suddenly, I started worrying because I didn't know where I was. I couldn't find my house on a map, a compass, and I didn't make a beacon or keep track of what side of the sun it was on either. How can I find my house again??? I have a custom search page for use in Customer Portal.  VF Page:    &lt;form name="frmSearch"&gt;      &lt;input type="text" name="keyword" id="keyword" value="{!portalSearchModel.searchTerm}" onkeypress="return noenter(event);" style="width:25%; height:25px;margin:0; padding: 0px 6px 0px;" placeholder="What are you looking for?" /&gt;      &lt;input type="button" id="btnSearch" name="btnSearch" value="Search" onclick="searchTerm()" class="go-we3" /&gt;   &lt;/form&gt;   &lt;script type='text/javascript'&gt;       function searchTerm(){         var searchTerm = document.getElementById("keyword").value;          var url="/apex/PortalSearch?s="+searchTerm;          window.location = url;          return false;     }          &lt;/script&gt;   Is there a way to call this apex method in Controller on button click along with the JavaScript?      public void logSearchTerm(){         portalSearchModel.searches();         Search_Log__c sl = new Search_Log__c();          sl.search_term__c = portalSearchModel.searchTerm;         sl.user__c = UserInfo.getUserId();              insert sl;  } Why can't you add attributes to object in python? Who are responsible for pushing out the OTA updates? There are many parties involved in an Android phone. My question is who is responsible for the OTA updates of my phone. Is it the manufacturer, the phone service provider or Google?  I thought this answer could be answered generally but maybe not. My phone is the Galaxy Nexus i9250 witch is manufactured by Samsung. Let $f:S^{2n} \rightarrow S^{2n}$ be a continuous map. Show that          there exists $x \in S^{2n}$, such that $f(x) =x$ or $f(x) = -x$;   any continous map $g: \mathbb R P^{2n} \rightarrow \mathbb RP^{2n}$ has a fixed point;      I think 1 implies 2. So, how can I find an $x$ in 1?  Thanks for the help. Difference In Eigenvectors If $R$ is an infinite ring, then $R$ has either infinitely many zero divisors, or no zero divisors Please help me to prove that if $R$ is an infinite ring, then $R$ has either an infinite number of zero divisors, or it has no zero divisors. "Will + be + verb -ing)" vs "Will + verb" ? Can someone explain me the constructions (or however they are called) with the "Will + be + verb -ing)" and the "Will + verb" ? How to prove $\cos \frac{2\pi }{5}=\frac{-1+\sqrt{5}}{4}$? I would like to find the apothem of a regular pentagon. It follows from   $$\cos \dfrac{2\pi }{5}=\dfrac{-1+\sqrt{5}}{4}.$$  But how can this be proved (geometrically or trigonometrically)? Are $_SESSION variables stored on the client or the server? Split-like environment inside cases environment I'd like to have a cases environment with some cases that are too long to fit on one line. I tried this:  \begin{cases}   \begin{split}     long expression \\ second line of long expression   \end{split} &amp; condition \\   ...   but I get the warning     Package amsmath Warning: Cannot use 'split' here;   trying to recover with 'aligned' on input line 201.   It automatically replaces the split with an aligned environment, which looks like this:    Is there any way to get these long expressions to behave like they were in split or multline environments, with the top line flush left and the next line indented a little? Why is cd not a program? How do I boot from ISO file stored on hard disk? If $A$ has two eigenvalues $\lambda _1, \lambda_2$ and $\dim (E_{\lambda_1})=n-1$, then $A$ is diagonalizable Lebesgue integral uniform convergence Let $f_n, f \colon [a,b] \to \mathbb{R}.$ Show that, if $f_n \to f$ uniformly, then the Lebesgue integrals are equal, i.e. $\int f = \lim \int f_n$.  This is clearly true for continuous functions, but how do I handle the case of non-continuous functions? Is there a problem with closing the lid of a MacBook Pro when using an external monitor? I am using an external monitor and the only way (that doesn't involve jumping through hoops) to turn off the MacBook Pro monitor is to close the lid.  Does closing the lid causes any problems? I have read the following on :     You can still run a single external monitor if you close the lid of   your laptop, but that restricts airflow and exposes your display to a   lot of heat. Not good. How to make a standalone document with one equation? I was surprised to find that standalone package can not compile a document with an equation:  \documentclass{standalone} \begin{document} \begin{equation} % not working! F(V, T) = E(V) + D(T) \end{equation} \end{document}   Is there an option or some workaround that allows this? The current error is something like:   ! Missing $ inserted.   in line 4. (The idea of course is that the including (main) document can just \input the standalone without knowing if is going to be an equation or something else) I'm thinking that one way Jeff and the Stack Overflow team could squeeze some extra money out of this site would be to automatically convert all Amazon links posted here into affiliate links, e.g. Stick "tag=codinghorror-20" (or more likely a new site-specific tag) onto every Amazon link. This would bring in some additional revenue every time someone purchased a book via a link on this site.   They could do similar things with other links as well. Amazon's simply the most obvious choice.  So my question is, would anyone have a problem with this?  I know I wouldn't mind, but I don't know how other people would react.  What does everyone think? Is this a horrible idea, a great idea, a waste of time?