Whoa. That's actually quite scary since I had no idea about it. What if I had selected only the "DELETE FROM table" from "DELETE FROM table WHERE id = 123"?! Now I have to worry about having done that (or something similar) in the past. :/
On 2015-02-12 at 10:23 AM, "Robins Tharakan" <thara...@gmail.com> wrote: > >On 12 February 2015 at 02:33, <hushthatb...@hushmail.com> wrote: > >> I sometimes notice that it will randomly tell me that I have a >syntax >> error somewhere in it when I run it, without having changed >anything. If I >> just click somewhere else inside the window, such as placing the >marker in >> the end of the query, and execute it again, it will run. > > > >I have a good feeling that this is because the times when it >gives 'syntax >error' either by mistake or unknown to you, the SQL query window >has >something selected (by mouse / shift + arrow keys) and then (by >design) >PgAdmin runs just that piece of text. In most cases the obvious >error would >be Syntax Error since now its a partial SQL being sent off to the >PG >database... "if" this is happeneing, this is by-design and a >'feature'. In >fact most common SQL query consoles (GUI) happen to work like this. > >-- >Robins Tharakan -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
