Some guy came to #postgresql today. Described his problem, got additional question, and then … well .. I wouldn't believe if it didn't happen to me.
Here is log of on channel conversation:
17:52 < loincloth> heyo 17:53 < loincloth> i am getting a syntax error for a pretty simple insert statement 17:53 < loincloth> it used to be a one line statement and i added some newlines for readability 17:53 < loincloth> but i guess that fails? how can i do a multi line statement for readability? 17:53 < depesz> loincloth: sure you can. 17:53 < davidfetter> it wasn't the newlines that caused the problem 17:54 < depesz> loincloth: we can't really help debug you the problem without seeing the query. 17:54 < loincloth> hmm 17:54 < loincloth> yup 17:54 < davidfetter> paste the query and the error you got to a paste site 17:54 < davidfetter> then paste the resulting url here :) 17:55 < loincloth> davidfetter: something like this http://pgsql.privatepaste.com/7ef97547f0
So far so good. The pasted query (copied to preserve) was:
INSERT INTO table_name ("id", "name") VALUES (1, 'foo'), (2, 'bar'), (3, 'baz');
Which is clearly correct, and works ok. And here went the “cool" stuff:
17:55 < davidfetter> loincloth, not "something like." the actual query *AND* the actual error 17:55 < loincloth> actual query doesnt matter 17:55 < loincloth> i just changed table name and values 17:56 < davidfetter> yes it does 17:56 < loincloth> not actually 17:56 < loincloth> is the letter 'f' illegal where 'a' is not? 17:56 < loincloth> why would that matter 17:56 < loincloth> here is the error 17:56 < davidfetter> you're coming here for help. dictating terms is not going to help you get that help 17:56 < loincloth> lol 17:56 < loincloth> whatever chief 17:57 < janos_> haha 17:57 < davidfetter> ? 17:57 < janos_> ...and he leaves still witha technical problem 17:57 < janos_> and apparently an emotional one too
Apparently he (she?) left (I have join/part notices disabled, so I didn't see it).
Well. I assumed that perhaps he misunderstood what David said, and decided to talk in priv – after all – the guy still has problem with query. Here is log of conversation:
18:12 <depesz> why do you have problem when others try to help you? 18:12 <loincloth> lol 18:12 <loincloth> was that you i was talking to or are you just a concerned bystander? 18:12 <loincloth> i don't remember 18:13 <depesz> neither. 18:13 <loincloth> uhm 18:13 <loincloth> ok 18:13 <depesz> i don't understand the problem you're having with david help you. 18:13 <depesz> the query you showed clearly works without any problem. 18:13 <depesz> so the problem you had with other query is still unresolved. 18:13 <loincloth> not really 18:13 <depesz> what "not really"/ 18:13 <loincloth> look, i know what my actual table name and values are 18:13 <depesz> sure, btu we don't. 18:13 <loincloth> and those details are none of your business or davids 18:14 <loincloth> and i know that the query, with those values 18:14 <loincloth> works in one line 18:14 <loincloth> doesn't with a newline 18:14 <loincloth> if you want to help me, you can trust that 18:14 <loincloth> if you can't trust that, then just bug off? 18:14 <loincloth> i don't care much either way 18:14 <loincloth> until you lecture me about irrelevant bullshit 18:14 <loincloth> k thx 18:14 <depesz> it is not a matter of multiline 18:14 <depesz> check this: 18:14 <depesz> http://pgsql.privatepaste.com/5c2e9328a4 18:14 <depesz> i created a table, and ran the query you shoewed 18:14 <depesz> it clearly works. 18:15 <depesz> so - whatever is the problem with your original query - it is not in the query you showed us. 18:15 <loincloth> yes well perhaps it is line ending style, i don't know 18:15 <loincloth> you are obsessed with correctness here 18:15 <loincloth> what's it to you if i take your help or not 18:15 <depesz> is there any particualr reason why you don't want to ashow us the query that has the problem? 18:15 <loincloth> it's a stupid battle to be fighting 18:15 <depesz> ok. let me state my point: 18:15 <loincloth> no 18:15 <loincloth> thx 18:15 <depesz> 1. you have a problem with a query. 18:15 <depesz> 2. i want to help. 18:15 <depesz> 3. for some reason you are doing everything not to allow us help you. 18:15 <loincloth> i'm too lazy to figure out how to block this conversation 18:16 <loincloth> so please just stop bothering me 18:16 <loincloth> thx 18:16 <depesz> have a nice life. 18:16 <loincloth> i will, thanks
The paste I linked to contained:
$ create table table_name (id int4, "name" text); CREATE TABLE $ INSERT INTO table_name ("id", "name") >> VALUES (1, 'foo'), >> (2, 'bar'), >> (3, 'baz'); INSERT 0 3
Now. I am speechless. I was trying to help guy with a query problem (which clearly doesn't stem from newlines or “line ending style"), and was told to “bug off" and “stop bothering". Sure. I will.