[BUGS] Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

2010-06-05 Thread Farid Zidan
Title: Signature Greg, Obviously I do not agree. When 14 different databases by 14 different DBMS vendors from the largest to the smallest in the market can do a simple thing as a using a subquery that has distinct keyword and your DBMS can't, I would say your DBMS is at fault and is not

Re: [BUGS] Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

2010-06-05 Thread Farid Zidan
Title: Signature Craig I am not asking you to re-write my sql so the bug will not show. I am presenting you with sql that fails and shows the bug. If every time someone reported a bug you ask them to re-write their sql so the bug is not hit, that would not eliminate the bug. Also, you are

Re: [BUGS] BUG #5488: pg_dump does not quote column names - pg_restore may fail when upgrading

2010-06-05 Thread Dimitri Fontaine
Alvaro Herrera alvhe...@commandprompt.com writes: I don't think dumps must be human-readable is an argument to reject such a switch, as long as it's off by default. And I haven't seen any other valid argument either, so +1 from me. Well as Bruce said this option won't solve the OP's problem,

Re: [BUGS] Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

2010-06-05 Thread Dimitri Fontaine
Farid Zidan fa...@zidsoft.com writes: I am not asking you to re-write my sql so the bug will not show. I am presenting you with sql that fails and shows the bug. If every time someone reported a bug you ask them to re-write their sql so the bug is not hit, that would not eliminate the bug.

Re: [BUGS] Re: BUG #5490: Using distinct for select list causes insert of timestamp string literal to fail

2010-06-05 Thread Farid Zidan
Dimitri This is the last you will hear from me about this issue. I would have stopped repsonding long time ago, but I kept getting responses that required reply. Do not knock on the door if you don't want someone to answer the door. There is no point in spending more of my time explaining

Re: [BUGS] Re: BUG #5490: INSERT doesn't force cast from text to timestamp

2010-06-05 Thread Craig Ringer
On 5/06/2010 9:39 PM, Farid Zidan wrote: Craig I am not asking you to re-write my sql so the bug will not show. I am presenting you with sql that fails and shows the bug. Before writing this off completely, please read on. I suspect I may've misunderstood your argument, and on further