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" <tharakan@gmail.com> wrote:
>
>On 12 February 2015 at 02:33, <hushthatbush@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